Sale Difference in Two Years

[#1]

hi all...

I am a newbie in qlikview ,

So, please tell me how we Calculate Sale Difference for two years.

Hope for help....

thanx in advance.......

Best Regards --

Shekhar Munjal

[#2 · Accepted solution]

Hi Shekhar

According to Your question , You can use set analysis

current year sales= sum({$<Year={$(=Max(Year))}>}Sales)

previous Year Sales= sum({$<Year={$(=Max(Year)-1)}>}Sales)

now

column(2)-column(1)

hope it works

Thanks

[#3]

hi Vimlesh ...

this Expression start works for me ...

thanx.......

Best Regards --

Shekhar Munjal