Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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 😊