topic Re: how to create cumulative growth in straight table? in QlikView

how to create cumulative growth in straight table?

jim_chan — Sat, 16 Nov 2024 04:22:18 GMT

Hi guys,

I have a requirement.

I need to create a expression to calculate the cumulative growth.

Example: for Feb-18the cumulative growth is value of Feb - 13900-13000(base_amt) = 900. Then march is mar value 13700-13000 = cummulative growth from feb to mar is 700.

Then, add/sum up the cumulative growth = 900+700= 1600. 1600 is the cumulative growth.

I really dont know how to write in script, please help guys.

Rgds

Jim

Re: how to create cumulative growth in straight table?

jim_chan — Fri, 22 Feb 2019 08:47:41 GMT

Re: how to create cumulative growth in straight table?

sunny_talwar — Fri, 22 Feb 2019 13:32:16 GMT

You want this 1600 to be in a text box object? and also, base_amt is a field from the script? May be just do this

=Sum(value - base_amt)

Re: how to create cumulative growth in straight table?

jim_chan — Fri, 22 Feb 2019 14:00:34 GMT

Hi sunny,

I want the 1600 to be in the straight table like the screenshot as per attached, sunny. But I dont know how to do it.

Rgds

Jim

Re: how to create cumulative growth in straight table?

sunny_talwar — Fri, 22 Feb 2019 14:04:44 GMT

I guess you need to remove your month-year and value dimensions to get 1600

Re: how to create cumulative growth in straight table?

jim_chan — Fri, 22 Feb 2019 14:04:56 GMT

The base amt 13000 is based on country . Each country has an amt. Eventually, it will be a manual file and load into the script.

Re: how to create cumulative growth in straight table?

jim_chan — Fri, 22 Feb 2019 14:06:22 GMT

Cant remove the month year, as per requirement.