topic Re: How to add a column in pivot table in QlikView

How to add a column in pivot table

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

Want to add a column (TOTAL) before Region column

for example want to add rows(value under north 4, value under east 2 and west 1)so Total should be 7

avinashelite — Wed, 30 Aug 2017 06:06:28 GMT

you mean an additional text ? did you tried the calculated dimension or add the text in the label of the region dimension .....

In the presentation tab add the label for partial total

devarasu07 — Wed, 30 Aug 2017 06:10:31 GMT

Hi,

First try with "Total on Top" option in pivot table ---> presentation property

another method,

created calculated dimensional measure as like below (update your field accordingly)

aggr(sum(sales),itemNumber,itemColor,Grade)

Note: this cal.dim grant total won't be available.

Thanks,

Deva

Anonymous — Wed, 30 Aug 2017 06:23:24 GMT

Partial sum is disabled.

How to use calculated dimension?

Anonymous — Wed, 30 Aug 2017 06:39:33 GMT

This partial sum Option is disables in my chart

and want the following:-

for example

total east north South TBC west

7 2 4 - - 1

want to add column total in pivot table and total value(2+4+1) ie 7 should be shown under column total that is to be added

dineshm030 — Wed, 30 Aug 2017 07:11:35 GMT

Hi Saksham,

Could you send your QVW application?