Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

john_henry
New 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

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

[Gross Sales Order US Dollar Amount ] = -0


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


-Rob

john_henry
New Contributor III

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

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

john_henry
New Contributor III

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

What about less than 0 or greater than zero?

thkarner
Contributor III

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

Shouldn´t it be

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

?

Regards, Thomas

Not applicable

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

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

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

Can you post the expression you are using?

-Rob

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

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

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

=- means "select not 0".

-Rob

alaope2q
New Contributor II

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

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

afsar_shaikh12
New Contributor III

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

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.


Community Browser