Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Contributor III
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 "="

Highlighted
Contributor III
Contributor III

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

What about less than 0 or greater than zero?

Highlighted
Partner
Partner

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

Highlighted
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 ...

Highlighted
MVP & Luminary
MVP & Luminary

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

Can you post the expression you are using?

-Rob

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Contributor II
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

Highlighted
Creator
Creator

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.


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