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

[briwilli]

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 

[nikolay_dolgono]

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]

Thanks, that is the approach we are now taking.