Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Sub total Label in pivot table

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

1 Solution

Accepted Solutions
jerem1234
Valued Contributor II

Re: Sub total Label in pivot table

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!

View solution in original post

7 Replies
Not applicable

Re: Sub total Label in pivot table

Hi Fernando,

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

Partner
Partner

Re: Sub total Label in pivot table

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

Not applicable

Re: Sub total Label in pivot table

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

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

Partner
Partner

Re: Sub total Label in pivot table

Not really what a i need, thank you Smiricpet

jerem1234
Valued Contributor II

Re: Sub total Label in pivot table

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!

View solution in original post

anbu1984
Honored Contributor III

Re: Sub total Label in pivot table

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

Re: Showing Dynamic "Total Label"

jerem1234
Valued Contributor II

Re: Sub total Label in pivot table

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