Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks, that is the approach we are now taking.