topic Re: Running Total in QlikView

Running Total

Sun, 16 Nov 2014 09:17:37 GMT

Dear all,

I have a pivot table which have which have monthwise sale qty..now i want to apply running total in this table.

MarcoWedel — Sun, 16 Nov 2014 11:37:43 GMT

Hi,

one solution could be:

hope this helps

regards

Marco

Sun, 16 Nov 2014 12:09:47 GMT

Dear Marco,

Thnx a lot for ur reply. My problem is solve..

Regards,

Masba

MarcoWedel — Sun, 16 Nov 2014 14:25:09 GMT

Did you find another solution?

regards

Marco

Sun, 16 Nov 2014 15:15:46 GMT

try this

load

C as C_new,

NUMSUM(C, PEEK('C', -1)) AS C

table;

Mon, 17 Nov 2014 03:42:17 GMT

Dear marco,

By using ur solution i have solve my problem..

MarcoWedel — Mon, 17 Nov 2014 05:49:42 GMT

You can express this by selecting correct answer, if you like.

Thanks

Regards

Marco

MarcoWedel — Sun, 23 Nov 2014 22:37:19 GMT

Glad I could help.

Please close this thread if there are no further questions.

thanks

regards

Marco