Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
dylangargo
Partner - Contributor II
Partner - Contributor II

How to reference a column in a Pivot Table

Hi, 

I am working with a pivot table, I would like to know if it is possible to hide certain measures depending on the pivot. For example, for the image I attached, I would like to hide the "Distance" measure and show only the "Variation" measure. How could I do this?

Thank you

dylangargo_0-1677169780254.png

 

 

Labels (4)
3 Replies
sidhiq91
Specialist II
Specialist II

@dylangargo  Under Measure, we have something like Show column if, there we can specify when we need to show the column in the table.

sidhiq91_0-1677171003728.png

 

dylangargo
Partner - Contributor II
Partner - Contributor II
Author

I know but it is not working 😞 . It shows me "The calculation condition is not fulfilled".

dylangargo
Partner - Contributor II
Partner - Contributor II
Author

I write the following expression but it is now working ;(

dylangargo_2-1677176764053.png