Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis - graph appears to extend data line

I am using set analysis for one of the first times.  I have "sales" for years 2015, 2016, and 2017.  I am using =Month([Date]) as the Dimension which appears to work fine.  I have data for all of 2015, all of 2016 and through April of 2017.  All of this data is displayed correctly.

However, the 2017 line for April then goes on to May, June, July etc. with values of zero.  So it makes it appear as if there is data by extending the line.  I have no data, no blanks, no information or May - Dec of 2017 but yet the line extends.  I would like it to end with the last known value (sum of values).

Here is the analysis that I use for each year with only the "2015" changed.

Count({$<[Sales Category] = {'*2015*'}>} [Sales Category])

Any ideas?

1 Reply
sunny_talwar

Is the 'Suppress Zero Value' checked on the presentation tab? If it isn't make sure to check it. Also, if that doesn't work, may be try this for 2017 expression

If(Count({$<[Sales Category] = {'*2017*'}>} [Sales Category]) > 0, Count({$<[Sales Category] = {'*2017*'}>} [Sales Category]))