topic Re: The Label for Partial sums in the Pivot Table in QlikView

The Label for Partial sums in the Pivot Table

jixiaoquan — Mon, 24 Aug 2015 06:59:42 GMT

Hi everyone,

I have question about the label for partial sums in the pivot table.

There are three dimensions in the pivot table,GMNME,DIRECTORNAME and MARKETNAME, just one expressions.

I want to use the partial sums in the pivot table.

The total Label like 'GMNAME-Total'.The GMNAME is the content of GMNAME.like 'Ada-Total',in the Label for I write '=GMNAME&'Total'',but it does not work.

Could you tell me how to do?

Re: The Label for Partial sums in the Pivot Table

jonathandienst — Mon, 24 Aug 2015 07:06:25 GMT

Unfortunately the partial total labels cannot respond to the value of the dimensions and in your case, the value of GMNAME in the total label will always be null. I do not recall seeing a workaround.

Re: The Label for Partial sums in the Pivot Table

tresB — Mon, 24 Aug 2015 07:18:08 GMT

Kind of workaround could be like explained here: Custom Labels in Pivot Table or using Properties ->Style ->Indent Mode

Re: The Label for Partial sums in the Pivot Table

petter — Mon, 24 Aug 2015 08:15:12 GMT

If you are willing to accept an extra column in the form of an expression this might work for you:

You must put a space character in all the Sub Total Lables.