Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
briwilli
Contributor
Contributor

Creating a line chart that auto-generates missing values on the X-Axis

I have a request form our client to allow users to create line charts that will have year as the X-Axis and show the year values with proportional spacing that will accommodate missing year values.  For instance, if the user selects years of 2005 - 2010 plus  2017, and 2018, then the chart would show these years. with the correct spacing between the data points.  So between 2010 and 2017 data points, there would be space that is proportional to the missing years.  Excel will autogenerate the missing years when you create this type of line chart.  Can anyone tell me if this is possible with Qlik Sense? 

Thanks

Brian 

Labels (2)
2 Replies
nikolay_dolgono
Partner
Partner

Hello, Briwilly! 

It is possible. You should check some points:

1. Your data contain every year you want to show. Generate missed data using ETL if not

2. Uncheck supress zero values in chart properties

3. Make your expression in this way

Sum(Field)

*

fAbs(Count({1}Year) > 0)

Where Sum will calculate your measure and fAbs will make interval to show

Done. You can use IF construction, but this method works faster

briwilli
Contributor
Contributor
Author

Thanks, that is the approach we are now taking.