topic Re: cumulative subtracting in QlikView

cumulative subtracting

kumarkp412 — Tue, 17 Mar 2015 10:22:52 GMT

Hi friends,

I am having small problem to calculate the cumulative subraction.

I´m Looking for a formula that can calculate the total value subtract the current value

i.e this is table i am having

year	sales
2009	100
2010	200
2011	300
2012	400
2013	500

i want to calculate the cumulative subtract as total value - current value

year	sales	cumulative-sub
2009	100	1400
2010	200	1300
2011	300	1200
2012	400	1100
2013	500	1000

So in the above table cumative sub will come base on total sales of the years - current sales

i.e total sales =1500 ,current year sales- if it is 2009 then the sales is 100 , then value is 1500-100 = 1400

i am not able to get the formula for that .

can any suggestion please

Thanks

Kumar

Re: cumulative subtracting

mightyqlikers — Tue, 17 Mar 2015 10:27:02 GMT

Hi Praveen,

use the folloing expression.

=Sum(TOTAL Sales)-Sum(Sales)

Regards

Samwise

Re: cumulative subtracting

mightyqlikers — Tue, 17 Mar 2015 10:27:50 GMT

Please find the attached qvw

Regards

Samwise

Re: cumulative subtracting

kumarkp412 — Tue, 17 Mar 2015 10:58:00 GMT

Hey Sam,

Thanks for reply,

When it was a straight table it is coming correctly , but it is a pivot table.then it is not coming correctly.

can you give me suggestions in to create it in pivot table

Thanks

Kumar

Re: cumulative subtracting

mightyqlikers — Tue, 17 Mar 2015 11:00:38 GMT

it is working fine even in pivot table.

please attaché your sample qvw.

Regards

Samwise

Re: cumulative subtracting

Anonymous — Tue, 17 Mar 2015 11:04:13 GMT

Hola,

PFA

HTH

Re: cumulative subtracting

kumarkp412 — Tue, 17 Mar 2015 13:47:18 GMT

ok sure

I will attachement my sample

Re: cumulative subtracting

kumarkp412 — Tue, 17 Mar 2015 14:47:55 GMT

This is sample qv.

In that i have given how i want to represent the values in the table.

Thanks

Kumar