topic Set Analysis, Alternate States, Prior Year in QlikView

Set Analysis, Alternate States, Prior Year

brentdej — Mon, 05 May 2014 17:23:18 GMT

I am using Set Analysis (QV11) with Alternate States and am trying to get a prior year calculation. The expression below works for the selected year, and is summing for the selections in the alternate state (GroupOne) but applying the time dimension selections in the default state. I can't seem to modify this to get a prior year calculation. The Year is a character string.

sum({GroupOne<Year = $::Year, Month = $::Month>} PremiumByPolicy) * .001

Thanks in advance...

Re: Set Analysis, Alternate States, Prior Year

Gysbert_Wassenaar — Mon, 05 May 2014 17:47:00 GMT

Perhaps like this:

sum({GroupOne<Year = {'$(=max({$}Year)-1)'}, Month = $::Month>} PremiumByPolicy) * .001

If not, please post an example document with sample data.

Re: Set Analysis, Alternate States, Prior Year

brentdej — Mon, 05 May 2014 17:52:32 GMT

Thank you!

That worked perfectly.

Brent