Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate Difference column

Hello,

Next example

First column year with totals pro week for years 2014 and 2013

2014                       2013

52 100                    150

51 200                     200

50 300                    600

49 400                    350

Now i want to add 2 columns pro year.

First column shows me the difference amount. Column next to it shows me the percentage growth / lost toward previous year.

2014                                  2013

52 100   -50     33,33%        150

51 200   +0            0%        200

50 300   -300         -50%      600

49 400   +50          14%       350

How to do this?

10 Replies
Not applicable
Author

Everybody , but it won't succeed.