Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP

Continuous Axis Line Chart not working with missing values options

No ratings
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

Last Update:

May 10, 2022 3:20:13 PM

Updated By:

Jamie_Gregory

Created date:

Oct 7, 2019 4:41:22 AM

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)
Comments
Or
MVP
MVP

For anyone like me who regularly has to revisit this issue, there's an idea on the Community for fixing it:

https://community.qlik.com/t5/Suggest-an-Idea/Fix-continuous-line-chart-s-display-of-missing-values/...

 

Version history
Last update:
‎2022-05-10 03:20 PM
Updated by: