topic Variable Creation for set Analysis in QlikView

Variable Creation for set Analysis

NavinReddy — Sat, 04 May 2013 14:30:55 GMT

Hi All,

I have a Query will you plz help me any one

I need to be create one Variable ,It should disply Previous Three Years Data,

One more Variable should display Current Year Data

Will You plz help me

Thanks in Advance

Niranjan

Sun, 05 May 2013 08:27:29 GMT

vCurrentYear = Year(Today())

vPreviousThreeYears = Year(Today()-3) //This gives you the year for three years ago.

if you are talking about Rolling3threeYears i would do llike this:

vRollingThreeYears: ='>=Year(Today()-3) <=Year(Today())'

NavinReddy — Sun, 05 May 2013 10:23:25 GMT

Thanks a lot it will really helpful

Thanks & Regards

Niranjan