topic Re: if statement in QlikView

if statement

shree909 — Sun, 05 Aug 2012 00:28:32 GMT

i have yeaid as 0,-1,-2,-3,-4 and i have filling date.so i have to build a pivot table

for example----if the yearid=0,filling year is 2012

if it is -1 it has to show 2011 and if it is -3,-4 it shows 2010 and 2009 like this.

so i have written a expression year(sum{<yearid=0>}filling date).. so i stored in a variable

for -1 i just added -1 to the expression and stored in a variable ,for -2,-3 and -4 i did the same thing.

these dates i have to use it in the diemension when i clik onyearid=0 it shoiuld display,2012, if yearid=-1,2011

i can display if i select 1 year, but if i select more than one yearid it displays null.finally yearid valuses should be driven by the filling year.

so how to use using if statemetn.

can somebody help me plz

Anonymous — Sun, 05 Aug 2012 18:07:59 GMT

I don't understand why all this is needed. Why don't you select years themselves - 2012, 2011, 2010, 2009?

shree909 — Sun, 05 Aug 2012 18:36:43 GMT

The thing is i dont have a year, i have only for 0 yr and i need to calcualte for the past 5yrs

Anonymous — Sun, 05 Aug 2012 19:47:48 GMT

You can do it in the script (on the front end too) without any if.

You know the current year - it is year(ReloadTime()). So, for any yearid, the year is

year(ReloadTime())+yearid

That gives you:

0 2012

-1 2011

-2 2010

...