Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Tags (1)
1 Reply

Re: Cumulative to Non-Cumulative

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

Community Browser