# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP

## 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

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 "="

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?

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

MVP

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

Can you post the expression you are using?

-Rob

MVP

## 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

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

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.