topic Re: Disable total/partial sum in pivot table in QlikView

Disable total/partial sum in pivot table

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

Hello,

I would like to know if there is a way to disable partial / total sum of values in a pivot table. I tried by checking "Total Mode -> No Totals" and in Presentation tab unchecking "Show partial sum" but it`s still not working.

I would like to have something like this:

Metric1		10 000
	Metric2_1	60
	Metric2_2	40
	Metric2_3	50
	Metric2_4	20
	Metric2_5	30

Each Metric is beeing calculated at reload and I would like to present them in a PivotTable using Indent Mode. But every time for Metric1 I get the sum of Metric2 values.

Thank you,

Razvan

Re: Disable total/partial sum in pivot table

itec_pao — Tue, 17 Apr 2018 06:18:03 GMT

Hi Razvan,

In Intend mode, it shows you the partial sums. In order to get rid of that you use the function dimensionality(). Your expression would look like:

if(Dimensionality()>1,sum(Value), ' ')

This calculates everything where the dimensionality is greater then 1 and for the dimensionality = 1 (Metric1) puts just a space.

Regards,

Oktay

Re: Disable total/partial sum in pivot table

razvan_brais — Tue, 17 Apr 2018 06:22:16 GMT

Hey Oktay,

Thanks for your answer. This is partially correct , but I would like to show the value for Metric1 which is also calculated at reload time and it has a different value than the sum of Metric2...

Re: Disable total/partial sum in pivot table

itec_pao — Tue, 17 Apr 2018 06:35:29 GMT

Then you can use the same functionality:

if (Dimensionality()=1, sum(something), sum(something_else))