Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative to Non-Cumulative

Please note that database contains cumulative figure, however I wish to load the figure non-cumulative form. For eg, in Jan, revenue is 100, in Feb, it is  210 which cotains Jan Figure also. I wish to load 110 as Feb Revenue instead of 210. Please provide script which can be used to create non-cumulative figure while laoding.

1 Reply
marcus_sommer

Within a sorted (resident) load you could with the functions peek() or previous() access the previous rows and therefore calculate the difference between them - see to how it worked to this example: Peek() vs Previous() – When to Use Each.

- Marcus