topic Pivot table turning on/off subtotals per expression in QlikView

Pivot table turning on/off subtotals per expression

Wed, 26 Nov 2014 08:41:03 GMT

Hi guys,

I have a pivot table with several dimensions and expressions. I am using the subtotals function which shows the totals for every expression used in the pivot table. But some expressions subtotal doesn't makes sense, or not needed for analysis. Is there a way to turn on/off subtotals for each expression? If the answer is yes, then how?

Thank you for your answers!

BR,

Re: Pivot table turning on/off subtotals per expression

Gysbert_Wassenaar — Wed, 26 Nov 2014 08:49:46 GMT

You can't turn them off. But you can try using the dimensionality() function to make the text transparent. Click on the + sign in front of the expression, select Text Color and enter an expression like =if(dimensionality()<>3,black(),white(0)). Change the 3 to the value that's appropriate in your chart. See attached example.

Re: Pivot table turning on/off subtotals per expression

Wed, 26 Nov 2014 08:55:00 GMT

As Gysbert says, no not a real way to turn them off unfortunately, oh how I wish there was!

Re: Pivot table turning on/off subtotals per expression

Wed, 26 Nov 2014 09:00:04 GMT

Thanks Gysbert, it works!