Skip to main content
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!