topic Re: Calculation on Partial Sum in QlikView

Calculation on Partial Sum

Mon, 04 Jan 2016 09:53:49 GMT

Greetings

Please help to calculate the difference of the partial sum on Pivot table.

Please advise how can I calculate the difference between the sum of 1st column vs 2nd column and so on on a Pivot Table.

Thanks!!

sasikanth — Mon, 04 Jan 2016 10:27:50 GMT

HI,

use above function

Ex:

Sum(sales)-above(sum(sales))

Mon, 04 Jan 2016 11:10:06 GMT

Thanks Sunny!

But unfortunately it's not working.

Please find attach the qvw file.

Thanks.

sasikanth — Mon, 04 Jan 2016 11:21:56 GMT

Hi,

PFA , see the last column

Mon, 04 Jan 2016 11:25:15 GMT

Thanks Sunny.

Is it possible if only last column will be displayed?

Thanks.

sasikanth — Mon, 04 Jan 2016 11:38:59 GMT

HI,

i don`t think so , it will apply on all columns

sunny_talwar — Mon, 04 Jan 2016 11:57:57 GMT

By last column you mean just the totals column?

Mon, 04 Jan 2016 12:22:19 GMT

Yes. Just the total column.

Thanks.