topic Re: Sub Total Titles in a pivot table in QlikView

Sub Total Titles in a pivot table

Fri, 02 Dec 2011 15:27:43 GMT

I cannot put an expression in the property where you can put the title for a subtotal in a pivot table.

If I just paste a field as 'Customer' ... the result is a ' - '

But if I put something as a text ...that works ...

Any helps?

Thanks in advance

Sub Total Titles in a pivot table

Fri, 02 Dec 2011 15:41:06 GMT

I mean the label of the Subtotal

Sub Total Titles in a pivot table

Fri, 02 Dec 2011 15:43:31 GMT

The issue might be that the Subtotal label is not looking at your dimensions.

I bet that if you use the field Customer as the label, and then select a single Customer it works?

Sub Total Titles in a pivot table

Fri, 02 Dec 2011 15:50:21 GMT

That's true Marcsiliving ... the point is that I need to show one or more dimension .... in the same pivot at time.

Re: Sub Total Titles in a pivot table

Fri, 02 Dec 2011 15:54:36 GMT

I ran into the same issue when I wanted the label to change based on the dimension.

I was never able to find a solution and ran into to many other issues so I just created what I needed in Crystal Reports. (In my case they needed only the Excel export, not to actually see the data and how it changes)

Edit: I just did a search and found this: http://community.qlik.com/ideas/1156#comment-2442

Seems like it is not currently available.