topic Re: Sub total Label in pivot table in QlikView

Sub total Label in pivot table

fkeuroglian — Mon, 19 Jan 2015 12:48:10 GMT

Hi expert

i would like to know if there is the possibility to change the label in the pivot table

my problem is that if i change one sub label, the other is changed too

i attached the image, and mark what label i want to change, but i want to put diferent text in that two label

thank you a lot

Fernando

Re: Sub total Label in pivot table

Mon, 19 Jan 2015 13:11:16 GMT

Hi Fernando,

you should go to the properties of the graphic and write which is the name for the total label

Re: Sub total Label in pivot table

fkeuroglian — Mon, 19 Jan 2015 13:25:27 GMT

Hi Smiricpet, If I write the label there(where you indicated) the two sub label will change, and they will have the same sub total label, i want to put TWO DIFFERENT labels,

if i do what you said, i wirte TESTLabel and appers in the two sub total, i want put testlabel1 and in the other Testlabel2

(attached an image)

thank you

Re: Sub total Label in pivot table

Mon, 19 Jan 2015 13:53:33 GMT

check this and let me know if it deal with ur porblem:

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

Re: Sub total Label in pivot table

fkeuroglian — Mon, 19 Jan 2015 14:01:17 GMT

Not really what a i need, thank you Smiricpet

Re: Sub total Label in pivot table

jerem1234 — Mon, 19 Jan 2015 14:47:06 GMT

This is not possible, the best thing you can do is just have a label like "Titulo Total". The labels can't change based on the different dimension values in a field. It's a one or nothing kind of deal.

Hope this helps!

Re: Sub total Label in pivot table

anbu1984 — Mon, 19 Jan 2015 15:09:11 GMT

If you want to add labels on total expr, check this link

Re: Showing Dynamic "Total Label"

Re: Sub total Label in pivot table

jerem1234 — Mon, 19 Jan 2015 15:12:57 GMT

Oh that's a neat trick! Thanks for that one! Never thought of not using the label and just include into the value.