topic Re: Running Total Not Calculating As Expected in QlikView

Running Total Not Calculating As Expected

pnn44794 — Wed, 25 Nov 2020 16:16:04 GMT

Hello:

I have a straight table where I need to calculate a running total, but what I've tried thus far is not working.I'm stumped as to why the solution does not work and I'm guessing I'm missing something simple.

Re: Running Total Not Calculating As Expected

felipedl — Wed, 28 Jun 2017 12:57:15 GMT

Hi Perry,

Thing is that the condition for your if statement is always true (see below) and giving you the $25.00 M value.

Use the RowNo() at script level to mark your table with each value.

Re: Running Total Not Calculating As Expected

pnn44794 — Sun, 13 Oct 2019 18:11:48 GMT

Hello Felip:

Thanks for the reply. How would I do this at the load script level? How would I code it?