topic Re: Cumulative Sum on the previous commun Columns in QlikView

Cumulative Sum on the previous commun Columns

RanOuerg — Thu, 03 Mar 2022 09:44:51 GMT

Hello,

i need help to solve this issue , i've tested many codes but still not working on QlikView scripting, I have a data base with Country, Material , Qty

I need to calculate the cumulative Qty for all the previous rows if the key(Country, Material) is equal to the previous one than i do the sum like the example marked in Yellow here bellow row by row.

i used Peek but it doesn't work well for my case

Is there any solution to apply this rules in the chart area?

Thank you in advance!

Re: Cumulative Sum on the previous commun Columns

hic — Thu, 03 Mar 2022 10:51:52 GMT

In the Load script you can do a

If(Country=Peek(Country) and Material=Peek(Material), RangeSum(Qty,Peek(CumulativeQty)), Qty) as CumulativeQty,

Just make sure that you have ordered the rows with an "Order By".

In a chart, you can do something similar using Above() instead of Peek().

Re: Cumulative Sum on the previous commun Columns

RanOuerg — Thu, 03 Mar 2022 13:59:23 GMT

Hello,

Yes with the order by it work very well, Thank you!

Re: Cumulative Sum on the previous commun Columns

RanOuerg — Mon, 21 Mar 2022 13:19:56 GMT

Hello Henric,

I applied the formula but now while doing the test i have duplicated lines whenever i added the CumulativeQty

and i can't use Distinct since i already search recurrences can you help with that ?