Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Sale Difference in Two Years

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Sale Difference in Two Years

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

View solution in original post

2 Replies
Highlighted
Not applicable

Sale Difference in Two Years

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

View solution in original post

Highlighted
Not applicable

Sale Difference in Two Years

hi Vimlesh ...

this Expression start works for me ...

thanx.......

Best Regards --

Shekhar Munjal