topic Re: Pivot without some totals in QlikView

Pivot without some totals

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

Hi all.

I have a pivot and, for some expression, I don't want their totals at the right. In expression I an't select NO TOTALS and also in presentation I can't say not tu sum. thanks in advace!

Re: Pivot without some totals

MK9885 — Wed, 09 Nov 2016 21:04:37 GMT

To remove totals uncheck the 'Show Partial Sums' for Dimension values in presentation tab.

It will remove Totals for the expression column for that particular dimension only.

I do not know other way around to do it, maybe a Qlik expert can suggest more?

Re: Pivot without some totals

Thu, 10 Nov 2016 10:20:19 GMT

Check @Stefan Wühl solution here How to Remove Total & Sub Total from One Column in Pivot Table?

Re: Pivot without some totals

javierortiz79 — Thu, 10 Nov 2016 19:46:33 GMT

Hello Cristina,

Create a new expression and enter this: Dimensionality(),

That will give you a number for your totals, then use that number for an if condition in your expresion you don't need the totals, like this:

If(Dimensionality() = 1, sum(sales), )

Assuming that the result for the total of Dimensionality() <> 1.

This will solve your issue.

Regards!

Re: Pivot without some totals

maxgro — Fri, 11 Nov 2016 12:17:48 GMT

dimensionality for colums

secondarydimensionality for rows (pivot)