topic Re: Total lable in a Pivot table in QlikView

Total lable in a Pivot table

Anonymous — Thu, 21 Jul 2011 07:45:21 GMT

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.

Re: Total lable in a Pivot table

derekjones — Thu, 21 Jul 2011 09:08:30 GMT

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

Re: Total lable in a Pivot table

Anonymous — Thu, 21 Jul 2011 18:00:26 GMT

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?

Total lable in a Pivot table

johnw — Thu, 21 Jul 2011 23:38:14 GMT

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.

Re: Total lable in a Pivot table

Anonymous — Mon, 25 Jul 2011 11:07:21 GMT

Thanks for answer John.

Maybe you know an other way to create these groups?

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

Thanks,

Dennis.