Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Garfunkal
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
Garfunkal
Contributor III
Contributor III
Author

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