topic Re: last but one year in QlikView

last but one year

Mon, 24 Feb 2014 19:41:19 GMT

Hi i have requirement like displaying sales of last but one year not current year-1.

year field is like 2014 and 2011 and 2008 like this not in order .

Nicole-Smith — Mon, 24 Feb 2014 19:43:08 GMT

You can find the second highest year by using:

max(Year, 2)

So to sum sales, something like:

sum({<Year={$(=max(Year, 2))}>}Sales)

hic — Mon, 24 Feb 2014 19:46:10 GMT

In the script, in the master calendar you should define a flag for last year:

If( Year(Date) = Year(Today())-1, 1, 0) as IsLastYear,

Then you can use this in a Set Analysis expression:

Sum ( {$<IsLastYear={1}>} Amount )

HIC