Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

Suppress 0 value measures in Simple Table (w/ Links)

I'm using Qlik Sense Simple Table (w/ Links). Screenshot as below:

st.PNG

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!

5 Replies
satishkurra
Specialist II
Specialist II

In QlikSense "No"

poojashribanger
Creator II
Creator II

In expression you can write

if(sum(expn)>0,sum(expn))

priyalvp24
Creator
Creator

Hi,

In Add-On

Untick Include 0 values


Thanks,

Priyal

wanyunyang
Creator III
Creator III
Author

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.

wanyunyang
Creator III
Creator III
Author

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.