Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
dylangargo
Partner - Contributor II
Partner - Contributor II

Hide columns in a Pivot Table

Hi guys, 

I am using a pivot table and would like one of the measures to change its label depending on the pivot. However, it doesn't work for me. Do you know if I am making a mistake in the condition?

 

dylangargo_0-1677281688828.png

 

Labels (1)
1 Solution

Accepted Solutions
sidhiq91
Specialist II
Specialist II

@dylangargo  Could you please use one of the below expression:

if(Match(id_desc_metricas,1,2,3),'Distancia','Variacion')

or

if(wildMatch(id_desc_metricas,*1*,*2*,*3*),'Distancia','Variacion')

If this resolves your issue, please like and accept it as a solution

 

View solution in original post

1 Reply
sidhiq91
Specialist II
Specialist II

@dylangargo  Could you please use one of the below expression:

if(Match(id_desc_metricas,1,2,3),'Distancia','Variacion')

or

if(wildMatch(id_desc_metricas,*1*,*2*,*3*),'Distancia','Variacion')

If this resolves your issue, please like and accept it as a solution