Running Total Scenario

[arsal_90]

Hi Members,

Need help in the attached scenario. Problem is that when i calculate rolling total on expression level it didn't change on Product.

Please see the attached data. In Sheet Input, you have to used that data and what the result i want is in Desired Output Sheet.

Thanks,

Arsalan

[Chanty4u]

hi

u can try dis expression in chart

RangeSum(above(sum(Reqmt),0,RowNo()))

hope this helps u

Thank you

suresh

[Gysbert_Wassenaar]

Like this:

LOAD

     Location,

     Date,

     Quantity,

     if(Previous(Location)=Location, rangesum(Quantity,peek(Cumulative)),Quantity) as Cumulative

FROM Cummulative Scenario.xls (biff, embedded labels, table is Input$);

[Chanty4u]

hi

PFA,

hope this helps you

Suresh

[arsal_90]

Hi Gysbert,

I try this but no success. Could you please see my data set in attachment (Testing.qvw and Fact.qvd). Really appreciate your help. Pleasee.

Thanks

[qlikviewwizard]

Hi arsal_90 , Did you try gwassenaar‌

's solution? It will work.

[#7]

Hi

i got correct only i mean u r desired output u can see this

[settu_periasamy]

Hi,

same thread here also. Have you tried this?. Just now i posted the file using your 'Fact.qvd'

Running Total Issue

[qlikviewwizard]

Hi arsal_90,

Can you please close the thread by selecting Correct Answer.

I think Jagan Mohan's reply is the correct one. Thanks.