Qlik Sense - Hide a measure when variable value is 0

[#1]

Hey guys,

I have the following problem. I've got a table consisting of 3 columns. The first column is called description. The secon column contains the values for measure one for all products. The third column contains the values for measure two for one product (so if you divide the value of measure 1 by the numer of products, you got measure 2.) 

I want to provide the custmer the possibility to choose, wheather he wants to see the 2nd measure or not (so he has to turn on/off the button to change a variable vSetVisbility) . Is this possible and if so, how?

thanks a lot.

Bye

[paul_scotchford]

There is no function in QS that allows the user to selectively switch off an object or field on a sheet, however you can use the extension found here Qlik Branch and then use conditional text coloring to blank (eg Set color to white) out the field in question, this of course will not switch off the whole column (as can be done in QlikView) ,but at least the field value is not visible.

Hope this helps a bit.

[reddy-s]

Hi Michael,

You need to go with an extension to achieve this. As Paul suggested, checking if there is an extension available on Qlik Branch would be helpful. If there is no such extension, you still have the leverage to build an extension to fit your case.

Thanks,

Sangram.

[#4]

Thanks for your fast reply.

I already have an "Button"-extension to change values of variables and this works fine. Unfortunately displaying the values with white color is good idea, but it doesn't fit into my concept 😉 Again - Thanks a lot!

Michael