Discussion Board for collaboration related to QlikView App Development.
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?
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.
View solution in original post
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.
Kind of workaround could be like explained here: Custom Labels in Pivot Table or using Properties ->Style ->Indent Mode