Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
MrAndrews
Contributor III
Contributor III

Change Totals Label in a Pivot

Hiya.

SS.png.jpg

I have a Pivot in Qlik Sense - with two Dimensions on the left, and Month as a secondary dimension horizontally, with two measures.  

The requirement  is to have the two 'totals' columns as a latest Month Only and YTD value.  I've been able to get this to work successfully within the Measure expression using:

if(ColumnNo()=0, >>Do totals processing<<, >>Do measure processing<< )

 

Now I want to change the Totals Labels - Highlighted in Yellow. Measure A to be MO Var, and Measure B to be YTD Var.  I cannot get it to do what iI want!  I can change the 'Total' Literal, but obviously that's of limited use.  I've messed with all the functions possible!  

I foolishly assumed if(ColumnNo()=0, 'Totals Label', 'Measure Label' ) would work... but no luck

Does anyone have any good ideas? I'd really appreciate it.



 

 

Labels (3)
1 Reply
MrAndrews
Contributor III
Contributor III
Author

sorry to repost, but does anyone have any idea how to go about this? Cheers!