Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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