Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sub Total Titles in a pivot table

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

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

4 Replies
Not applicable
Author

I mean the label of the Subtotal

Not applicable
Author

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?

Not applicable
Author

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

Not applicable
Author

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.