Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

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
Highlighted
derekjones
Contributor II

Re: Total lable in a Pivot table

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

Partner
Partner

Re: Total lable in a Pivot table

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?

MVP
MVP

Total lable in a Pivot table

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.

Partner
Partner

Re: Total lable in a Pivot table

Thanks for answer John.

Maybe you know an other way to create these groups?

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

Thanks,

Dennis.