Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator II
Creator II

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 II
Creator II
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 II
Creator II
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.