Set analysis - graph appears to extend data line

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Set analysis - graph appears to extend data line

sunny_talwar — Mon, 05 Jun 2017 21:14:39 GMT

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]))

topic Set analysis - graph appears to extend data line in QlikView

Set analysis - graph appears to extend data line

Re: Set analysis - graph appears to extend data line