Cumulative Sum on the previous commun Columns

[RanMH]

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!

[hic]

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().  

[RanMH]

Hello,

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

[RanMH]

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 ?