Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using Qlik Sense Simple Table (w/ Links). Screenshot as below:
Is there a way to suppress 0 value measures in this kind of table? There is no Add-ons-Data handling-Show zero values as in pivot table and straight table.
Thank you in advance!
In QlikSense "No"
In expression you can write
if(sum(expn)>0,sum(expn))
Hi,
In Add-On
Untick Include 0 values
Thanks,
Priyal
Hi Poojashri, thanks for helping. But 0 will be shown as NULL with this expression. And since it's a measure, I can't choose not to show nulls.
Hi Priyal, thanks for your reply. But as I mentioned, there is no Add-ons-Data handling-Show zero values in the type of table I'm using.