topic Re: Running Total Scenario in QlikView

Running Total Scenario

arsal_90 — Fri, 20 Nov 2020 18:02:30 GMT

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

Re: Running Total Scenario

Chanty4u — Sun, 05 Jul 2015 12:25:56 GMT

u can try dis expression in chart

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

hope this helps u

Thank you

suresh

Re: Running Total Scenario

Gysbert_Wassenaar — Sun, 05 Jul 2015 12:28:52 GMT

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

Re: Running Total Scenario

Chanty4u — Sun, 05 Jul 2015 13:01:30 GMT

PFA,

hope this helps you

Suresh

Re: Running Total Scenario

arsal_90 — Sun, 05 Jul 2015 13:14:35 GMT

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

Re: Running Total Scenario

qlikviewwizard — Mon, 06 Jul 2015 04:41:36 GMT

Hi arsal_90 , Did you try gwassenaar‌

's solution? It will work.

Re: Running Total Scenario

Mon, 06 Jul 2015 07:01:03 GMT

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

Re: Running Total Scenario

settu_periasamy — Mon, 06 Jul 2015 07:10:14 GMT

Hi,

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

Running Total Issue

Re: Running Total Scenario

qlikviewwizard — Mon, 06 Jul 2015 09:13:50 GMT

Hi arsal_90,

Can you please close the thread by selecting Correct Answer.

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