Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Total lable in a Pivot table

Good morning,

I would like some help labelling the total rows of a pivot table.

Thanks to krishnamoorthy I got a script that allows me to group my ID's bases on a level that is in an other field.

That works perfect for me. The only thing I still need is to give the Total label the name of the corresponding ID.

Please take a look at the attached document for more information.

Thanks.

Dennis.

4 Replies
derekjones
Creator III
Creator III

Hi Dennis

I can get you half way there..

For Level3 = 350, that's possible by just putting '='Total ' & Level3 in the "Label for Totals" box under Level2 on the Presentation tab of the properties.

For Level2 it's stumped me, because it wants to Sum up the quantity on Level2. I can't seem to get an individual label for each subtotal, it wants to put the same label on all?

Sorry I can't be of anymore help. It may at least give you a head start on trying to solve this.

Attached I've updated your qvw to show..

Hope this helps

Derek

Anonymous
Not applicable
Author

Thanks for trying Derek.

You are right, Sum is not the solution. I just need the ID there.

There must be a way, right?

Anybody?

johnw
Champion III
Champion III

I may be wrong, but I don't believe it's possible.  I believe that the total labels are evaluated once for the entire chart, not once per total.  It's annoying, as what you're asking for seems like a very obvious and basic feature.

Anonymous
Not applicable
Author

Thanks for answer John.

Maybe you know an other way to create these groups?

http://community.qlik.com/message/131018#131018

Thanks,

Dennis.