Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Nicole_902
Contributor
Contributor

How to exclude 0 values

Hi All,

I'm struggling with what I am sure will be a very simple solution. I am using the following formula as a way to remove any values that are less than 20K from my table. All values that would be >20000 are now showing as 0 but I want to remove them completely. 

Sum( {< SubCategory = {"Reg*"}, UserBudget = {">=20000"} >} UserBudget)

I would appreciate any advice!

 

Labels (3)
1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Nicole,

You should be able to clear the check box "Include zero values" in Chart properties, under "Add-Ons" --> "Data Handling". That should do the trick.

Cheers, 

View solution in original post

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Nicole,

You should be able to clear the check box "Include zero values" in Chart properties, under "Add-Ons" --> "Data Handling". That should do the trick.

Cheers, 

Nicole_902
Contributor
Contributor
Author

Perfect! I had to remove another column for this to work, but for the purpose I'm using the chart for that's not an issue. I knew there was an easy solution! I appreciate it 😊