Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Progressive values

Dear all, my legs are tied and I can't go on.

I don't know how to solve this problem. I've the following table:

Year Month     WhValue

2012     1          1000

2012     2          2300

2012     3          4500

2012     4          6900

2012     5          7500

....

...

WhValue is a progressive, therefore if I would know the exactly values per months , I should do  the difference between February and January (2300 - 1000) and so on.  How can I calculate these values in the script, in order to have the following table

Year Month    Value per Month

2012     1          1000

2012     2          1300

2012     3          2200

2012     4          2400

2012     5            600

Thanks in advance fopr your support

stefan

1 Solution

Accepted Solutions
Not applicable
Author

3 Replies
Not applicable
Author

Please see attached

Regards

Mhatim

Not applicable
Author

well test

Anonymous
Not applicable
Author

Great Cristina !!

Thanks very much