topic Re: Set Analysis with Chart Dimension in QlikView

Set Analysis with Chart Dimension

Anonymous — Mon, 20 Apr 2015 15:17:05 GMT

I understand that Set analysis is calculated only once per chart and not row by row. Is the only option to solve this; is by using an IF statement?

I have a sample application attached wherein I have used an IF statement but I do not get the right output. Can someone point me the right direction?

I want to calculate the difference in Sales over the Years. I dont want to use the ABOVE function. Wanted to see how it can done with IF statement. See the sample application attached.

Re: Set Analysis with Chart Dimension

robert_mika — Mon, 20 Apr 2015 15:47:31 GMT

Try:

=sum({$<Year={$(=max(Year))}>}Sales)-sum({$<Year={$(=max(Year)-1)}>}Sales)

Re: Set Analysis with Chart Dimension

Anonymous — Mon, 20 Apr 2015 17:57:25 GMT

I want the answer to be

Year Difference in Sales

1998 -58

1999 47

which I could get using Sum(Sales) - above(Sum(Sales)) with Year as dimension. Is there anyway to do it with IF statement and set analysis.

Re: Set Analysis with Chart Dimension

robert_mika — Tue, 21 Apr 2015 07:43:42 GMT

Above is designed to do that so I do not think there is a way but I maybe wrong and someone else has the answer.