topic Re: Perform calculation on variable in set analysis in QlikView

Perform calculation on variable in set analysis

mazacini — Thu, 12 Dec 2013 22:39:53 GMT

I have created a variable CurrYear to denote the Current Year. I have used it in Set Analysis to sum data where Year=CurrYear.

I have even included it in the labels in my chart to e.g. 'Sales '&$(CurrYear)

I have also shown previous year in label using 'Sales '&(num($(CurrYear))-1)

Now I want to use Set Analysis to sum data for last year. I hoped to use some version of the formula above
(ie num($(CurrYear))-1), but it does not seem to work.

What is my problem?

Re: Perform calculation on variable in set analysis

Thu, 12 Dec 2013 22:46:35 GMT

Try with

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

Re: Perform calculation on variable in set analysis

Thu, 12 Dec 2013 22:49:37 GMT

OR create a new variable PrevYear=num($(CurrYear))-1)

and then

sum({<Year={$(PrevYear)}>} Sales)

Re: Perform calculation on variable in set analysis

mazacini — Thu, 12 Dec 2013 22:51:12 GMT

Many thanks