Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
john_henry
Contributor III
Contributor III

How to create a Not Equal to Zero condition in Set Analysis?

I know how to do set analysis with text, but with numerical values, I'm not sure.   I have a condition where I need to exclude all $0 values from my calculation.  Here is my syntax so far:

[Gross Sales Order US Dollar Amount]-=0

How do I select where values are not equal to zero?

20 Replies
rubenmarin

Ohh, I forgot to test negative values, thanks for clarification Rob.