Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
arsal_90
Creator III
Creator III

Running Total Scenario

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

8 Replies
Chanty4u
MVP
MVP

hi

u can try dis expression in chart

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

hope this helps u

Thank you

suresh

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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$);


talk is cheap, supply exceeds demand
Chanty4u
MVP
MVP

hi

PFA,

hope this helps you

Suresh

arsal_90
Creator III
Creator III
Author

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
Master II
Master II

Hi arsal_90 , Did you try gwassenaar

's solution? It will work.

Not applicable

Hi

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

Capture1.PNG

settu_periasamy
Master III
Master III

Hi,

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

Running Total Issue

qlikviewwizard
Master II
Master II

Hi arsal_90,

Can you please close the thread by selecting Correct Answer.

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