# 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
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....

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

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

Highlighted
Not applicable

## Sale Difference in Two Years

hi Vimlesh ...

this Expression start works for me ...

thanx.......

Best Regards --

Shekhar Munjal