topic Re: set analysis in QlikView

set analysis

Anonymous — Sat, 03 Aug 2013 18:44:32 GMT

i want to compare current selection vs previous selection for budget rev.

I have declared 2 variables 1.vCurryear=max(year) other vPrevyear=vCurryear-1

Within one expression curr budget rev i have written the following -

Sum({$<Year = {$(vCurryear) ))}>} [Budget rev#]

why data is not coming?

should i declare another expression for other year?

i want to compare current vs previous year

Anonymous — Sat, 03 Aug 2013 19:06:46 GMT

There are some mistypigs here... Try this:

Sum({$<Year = {$(vCurryear)}>} [Budget rev#])

Anonymous — Sat, 03 Aug 2013 19:10:53 GMT

Hi I have resolved this .Your answer also correct.

sum({$<Year={$(=vPrevyear)}>} [Budget rev#])

Regards