nested If condition

shree909 — Wed, 01 Aug 2012 00:00:55 GMT

Hi ,

i have a year like 2012 and i need to calculate the last 4 years like 2011,2010,2009,2008 i am able to write the expressions and get it,

but these thosuld be implemented in pivot table, i wrote nested if conditions depending on 2012 but i am not able to display if 2 years selected at a time,

i can only get the one year selected

please can some one help me in writing if conditon to select the multiple years.

so how to write a if condition to select multiple years at a tym..

thanks

Re: nested If condition

Anonymous — Wed, 01 Aug 2012 01:48:13 GMT

If you want to write an expression that sums up something over the last 4 years based on the Max year value that you've selected you can use set analysis:

sum({$<Year={"<=$(=Max(Year))>$(=Max(Year)-4)"}>} ValueField)

topic Re: nested If condition in QlikView

nested If condition

Re: nested If condition