Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS

Continuous Axis Line Chart not working with missing values options

cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Continuous Axis Line Chart not working with missing values options

In a line chart, the x-axis field has missing values for some of the line fields. For example, a chart shows the selling data for different products each month. For some months, a product can have no data.
You may want to show this missing data as zeroes in the line charts, so for these months the line goes to zero, but it is not possible. The missing data are simply ignored and line chart just creates a straight line to connect the two most close points, even if there is missing data in the middle.
The chart is not responding to changes in options for "Missing Values".
No matter what is selected, "show as zeros", "show as gaps" or "show as connections" it is displaying as "show as connections".

So "show as zeros" and "show as gaps" seem not to work.

Environment:

Qlik Sense Enterprise on Windows 
Qlik Cloud 
Qlik Sense Business 

 

Resolution:

 

A good workaround is to avoid missing data, for example converting them -when it is possible- to zeros.

 

 

Cause:

In a continuous data model there is no way of knowing what the 'missing values' are, it depends entirely on the granularity of your data, e.g by day, by minute, by year etc. Without that information coming from engine we can't create gaps.

Labels (2)
Version history
Last update:
‎2022-05-10 03:20 PM
Updated by: