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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to display a dimension according to a condition

Hello,

I need to diplay in my pivot table the dimension material but only for reference who have a labor cost equal to 0. I thought I need to activate the condition (see printscreen below) but it doesn't work.Does anyone have an idea ?

Thanks ina dvance for your support.

Capture.PNG

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

That condition is to show or hide the entire dimension, not individual dimension values. Perhaps you want a calculated dimension instead: =if(DVC_Labor_GCR<>0, Material).


talk is cheap, supply exceeds demand