topic Re: PIVOT Table: NO Total for a column in QlikView

PIVOT Table: NO Total for a column

danosoft — Wed, 28 Apr 2021 14:41:53 GMT

Hi have this PIVOT table with two expression: Clienti and CONSUMO GAS

correctly it show me the Total for my Dimension (Partial Total), but i not want to show the TOTAL about CLIENTI in the end (Grand Total), is possible?

Re: Straight Table: NO Total for a column

edwin — Wed, 28 Apr 2021 14:31:37 GMT

i believe if you use a straight table you get the grand TOTAL, for pivot table it is partial sum

Re: Straight Table: NO Total for a column

danosoft — Wed, 28 Apr 2021 14:40:42 GMT

Sorry i wrong to write, is a PIVOT table, i want the partial total, but i NOT WANT to show the GRAND Total for expression CLIENTI, is possible?

Re: PIVOT Table: NO Total for a column

edwin — Wed, 28 Apr 2021 15:19:50 GMT

its not clear to me what the problem is, use Pivot and you can set Partial sums per dimension under the presentation tab

Re: PIVOT Table: NO Total for a column

danosoft — Thu, 29 Apr 2021 07:43:42 GMT

Yes right, Partial sums is not a problem, i NOT WANT to show the GRAND Total for my expression CLIENTI, is possible?

Re: PIVOT Table: NO Total for a column

edwin — Mon, 03 May 2021 14:05:42 GMT

can you pls attach a QVW so we can understand what the problem is?

Re: PIVOT Table: NO Total for a column

danosoft — Mon, 03 May 2021 14:30:57 GMT

Sure, i add an example, look i not want to show the GRAND TOTAL of field CLIENTI

Re: PIVOT Table: NO Total for a column

edwin — Mon, 03 May 2021 15:05:09 GMT

that gives a clearer picture of what you require.
the misunderstanding was that Clienti is an expression and not a dimension. also Pivot tables dont have grand totals it has partial sums.

so your requirement is to disable partial sum of one of the expressions and not partial sum of the dimension. unfortunately, pivot tables will show partial sums of all expressions and you can only control what dimensions have or dont have partial sums

Re: PIVOT Table: NO Total for a column

danosoft — Mon, 03 May 2021 15:21:39 GMT

😞

Re: PIVOT Table: NO Total for a column

edwin — Mon, 03 May 2021 18:36:44 GMT

hey you can always build your own extension. tables are the easiest extensions to build

Re: PIVOT Table: NO Total for a column

danosoft — Tue, 04 May 2021 06:32:13 GMT

How can i do that?

Re: PIVOT Table: NO Total for a column

edwin — Wed, 05 May 2021 18:47:12 GMT

heres a good place to start:

Qlik Tips: Beginners Guide to QlikView Extension Objects : Part 1