topic Re: Pivot table with Running sum as subtotal in QlikView

Pivot table with Running sum as subtotal

lucarizziero — Tue, 24 Sep 2013 15:33:16 GMT

I have the following Pivot Table

product	colour	date	cust. Order	running sum
141MBACAL0094	CR31	01/02/14	45	45
141MBACAL0094	CR31	02/02/14	19	64
141MBACAL0094	CR31	01/03/14	3	67
141MBACAL0094	OL71	01/02/14	52	52
141MBACAL0094	OL71	02/02/14	26	78

I'm not able to obtain the column named [running sum]: it should contains the running sum of the cust. Order column restarting each change of the combination product+colour dimensions.

Thanks

Re: Pivot table with Running sum as subtotal

v_iyyappan — Tue, 24 Sep 2013 16:07:50 GMT

Hi,

Use like this running sum

=If(Alt(Above(Sum(cust. Order)),0) = 0, Sum(cust. Order), (Sum(cust. Order) + Above(Sum(cust. Order)))

Regards,

Re: Pivot table with Running sum as subtotal

Tue, 24 Sep 2013 17:27:53 GMT

Please see attached

Re: Pivot table with Running sum as subtotal

Tue, 24 Sep 2013 18:00:03 GMT

I am also trying to do something similar to this. I would appreciate the help. I already tried what you suggested and it didn't work.

Thanks in advance,

Alba

Re: Pivot table with Running sum as subtotal

Tue, 24 Sep 2013 18:11:34 GMT

Thanks a lot for the example. I got it working!!

Re: Pivot table with Running sum as subtotal

lucarizziero — Mon, 30 Sep 2013 15:57:29 GMT

Your suggestioni is ok for my requirements: thanks a lot

Luca Rizziero

Da: V.Iyyappan Venkidusamy

Inviato: martedì 24 settembre 2013 18.25

A: Luca Rizziero

Oggetto: Re: - Pivot table with Running sum as subtotal

<http://community.qlik.com/> QlikCommunity

Pivot table with Running sum as subtotal

risposta da V.Iyyappan Venkidusamy <http://community.qlik.com/people/V.IYYAPPAN?et=watches.email.thread> su App Development - Visualizza la discussione completa <http://community.qlik.com/message/396486?et=watches.email.thread#396486>