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: 
qlikviewaf
Creator
Creator

Show data only if Greater than 0

Hi,

i created this chart that basically is the sum of SalesDistBudgetUSD

I would like to show on the graph this information only when >0 or different than null. Which is the right Syntax?

Thank you all!!

forum loading.PNG

3 Replies
sunny_talwar

The whole chart should only be visible if the condition is met or only this specific expression for Budget? May be try this as your condition

Sum(FieldName) > 0

qlikviewaf
Creator
Creator
Author

no only the value on the graph

for example, the red square below means that the VALUE is not available for the dimension "corporate adjsutment" since is 0 or null - i don't want to show only the value for that specific value of the dimension.

Hope its clear

forum loading.PNG

sunny_talwar

Did you try to check 'Suppress Zero Value' on the presentation tab? Also, have you checked if the number is 0 and not 0.001?