Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

[Gross Sales Order US Dollar Amount ] = -0


Note the position of the "-", to the right of "=".


-Rob

john_henry
Contributor III
Contributor III
Author

I don't see a change when I move the "-" sign to the right of "="

john_henry
Contributor III
Contributor III
Author

What about less than 0 or greater than zero?

thkarner
Partner - Creator III
Partner - Creator III

Shouldn´t it be

[Gross Sales Order US Dollar Amount]-={0}

?

Regards, Thomas

Not applicable

Or you use the if function instead of set analysis ...

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Can you post the expression you are using?

-Rob

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

-=  and =- are two different things in Set analysis.

-=0 means "remove 0 from the current selections".

=- means "select not 0".

-Rob

Anonymous
Not applicable

in this case i will use the if function

if [Gross Sales Order US Dollar Amount]  <> 0, Parameter


You can use any of your dimensions for the parameter

afsarshaikh
Creator
Creator

Use <[Gross Sales Order US Dollar Amount] -= {0}> if it's numerical value or

If it's a string use <[Gross Sales Order US Dollar Amount] -= {'$0'}> in your set analysis expression.


Regards,
Afsar Shaikh
Project Manager- QlikView Dev. & Support
Afsar Shaikh
Email- afsar.shaikh@live.com