Troubleshooting - Creating visualizations
This section describes problems that can occur when creating visualizations in Qlik Sense.
I cannot find the fields in the assets panel
I can find Charts and Master items in the assets panel, but not Fields.
Possible cause
You are working with a published app. Some content is not available in the assets panel in a published app.
My chart is not sorted correctly
I set my chart to sort automatically on the dimension, but the results are not sorted correctly.
Possible cause
The dimension is an expression with a result that has a different data type than the data fields used in the expression.
Proposed action
Change sorting of the dimension to Custom, and select a sorting option that matches the result of the expression. For example, if your expression concatenates two fields to a string, like Month(salesDate)&'/'&Day(salesdate), select to sort alphabetically.
For more information, see Change the sorting of a visualization.
My calendar measures display incorrect aggregations in visualizations
When I use my calendar measures in visualizations, I see incorrect aggregation results. For example, calendar measures created from identical fields and aggregations but different time ranges may display identical totals.
Possible cause
The table containing the aggregated field is not associated to the table containing the date field, preventing accurate aggregation of the field by the selected time ranges.
Proposed action
Create an association between the table containing the aggregated field and the table containing the date field. If there is no association possible, in Data manager, add a table that includes a date field that has an association to the table containing the aggregated field.
For more information, see Managing data associations.
There are no time ranges to select in Create calendar measures
When I have a date field selected in the Create calendar measures dialog try to create calendar measures from a field, there are no time ranges to select in the Create calendar measures dialog.
Possible cause
The selected date field does not have the correct time flags to work with calendar measures. If you have no valid date fields, you cannot create calendar measures. If you have at least one valid date field, all date fields will be available in Date field. However, only those with the correct time flags set in autoCalendar enable the selection of time ranges from the Time Range drop-down list.
Proposed action
Select a date field that uses autoCalendar. If you are unsure which calendar is associated to your date field, date fields in the Field section of the Assets panel display which calendar it uses when clicked.
My date field selected for calendar measures does not use the correct calendar
I have two calendars to which I have manually added time flags. My time flags have the same names as those in autoCalendar, making both qualified for use with calendar measures. However, only one of my calendars has the same definition for the time flags as autoCalendar. I have a date field associated to both calendars . When I try to create calendar measures using that date field, the calendar with the correct names but different definitions than autoCalendar is used.
Possible cause
In cases where a date field is associated to multiple calendars and each calendar has the correctly named time flags set in it, calendar measures uses the first qualified calendars defined in your data load script.
Proposed action
Move the script section containing the calendar you want to use with calendar measures before other qualified calendars in your data load script.
For more information, see Organizing the script code.
I cannot edit a variable value
I cannot edit a variable that is listed in the variables dialog.
Possible cause
The variable is defined in the script.
Proposed action
Edit the variable in the script, using the data load editor, or delete the variable from the script, using the data load editor, to make the variable editable from the variables dialog.
For more information, see Editing a variable and Edit the data load script.
The map is placing the locations in my location field incorrectly
When I add a location field to a layer in my map, the locations do not display in the correct places.
Possible cause
The map does not have enough context to locate the locations in your field. This can happen when a location in the field shares a name with a number of other possible locations on the map.
Proposed action
Set Scope for Location in your layer to Custom and enter additional information. Alternatively, qualify your location field using an expression that contains additional fields with relevant geographic information. If your location field contained cities and you had Country and State fields, you could use [City]&','&[State]&','&[Country].
No map is displayed
I am using Qlik Geoanalytics server, the background map is not displayed.
Possible cause
Your browser cannot access qlikcloud.com or your firewall settings or proxies prevent the use of JavaScript from qlikcloud.com. .
Proposed action
Visit the status page from your browser.
If your browser cannot access qlikcloud.com contact your system administrator for assistance.
If the page prints "ok" then your browser can access qlikcloud.com. Make sure that JavaScript from qlikcloud.com is allowed.
Do the following:
- Add https://*.qlikcloud.com as a trusted site. (recommended)
- Enable JavaScript from untrusted sites. (not recommended)
Error message: The data contains invalid geometries that could not be shown on the map. Review your data for errors and try again.
I loaded geoshapes from a KML file to Qlik Sense. When I try to add the field to my map, an error message tells me that my data contains invalid geometries that could not be shown on the map.
Possible cause
There is an error in your geometries that is preventing Qlik Sense from displaying them on the map or your geometry data may be in an invalid format.
Proposed action
Review your geometry data for errors and try again.
Error message: The following locations could not be found: <locations>. Review the values in your data and try again.
I added my location field to my map and I received an error messaging telling me locations in my location field could not be found.
Possible cause
Qlik Sense could not find the location. There may be a spelling error in the name or the location is not available in the Qlik Sense location database.
Proposed action
Review the values in your data for errors and try adding the field again. If a location cannot be found, you can alternatively manually add it using coordinates for points or geoshapes for areas.
Error message: The following locations could not be located: <locations>. Review the values in your data and try again.
I added a location field to my layer and I received an error message telling me that certain locations in my location field could not be located.
Possible cause
Qlik Sense could not find the location. There may be a spelling error in the name or the location is not available in the Qlik Sense location database.
Proposed action
Review the values in your data for errors and try adding the field again. If a location cannot be found, you can alternatively manually add it using coordinates for points or geoshapes for areas.
Error message: The following locations had more than one result: <locations>. Set a custom scope to clarify which locations to display.
I added a location field to my layer and I received an error message telling me that certain locations in my field had more than one possible result on the map.
Possible cause
One or more locations in your location field are ambiguous, with multiple possible locations on your map.
Proposed action
Set Scope for Location in your layer to Custom and enter additional information. Alternatively, qualify your location field using an expression that contains additional fields with relevant geographic information. If your location field contained cities, you , such as: [City]&','&[County]&','&[State].
Error message: Some lines could not be shown because of invalid data in the width expression. Review your data for errors and try again.
I entered a field or expression to control the width of the lines on my map and I received an error message telling me that certain lines have invalid data.
Possible cause
There is an error in your width expression that is preventing Qlik Sense from displaying specific lines on the map.
Proposed action
Your expression may contain non-numeric values. Review your data for errors and try again.
Error message: Some density points could no be shown because of invalid data in the weight expression. Review your data for errors and try again.
I entered a field or expression to control the density of the points on my map and I received an error message telling me that certain densities have invalid data.
Possible cause
There is an error in your weight expression that is preventing Qlik Sense from displaying specific densities on the map.
Proposed action
Your expression may contain non-numeric values. Review your data for errors and try again.
I added an image background layer and cannot see my image
I added an image background layer to my map visualization, but I cannot see it on the map.
Possible cause
Depending on the projection of your map and the scale of the image, the map may be too zoomed out to see the image.
Proposed action
Do one of the following:- In Map settings, enable Auto-zoom. Add a layer containing location data that would put it over the same area as your image background layer.
- In Presentation, enable Show debug info. The map now includes coordinates for the center of the displayed area.