# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## Set modifier with relational operator Not equal to 0

Hello,

I have a variable for 2017 transactions:

Sum({<ITEMTYPE={'I-P','P-P','P'},Year={2017},Trans<>{0} >}Trans)

I am trying to exclude transactions that equal "0.00" but it gives me an error in the expression.

1 Solution

Accepted Solutions
Honored Contributor II

## Re: Set modifier with relational operator Not equal to 0

Hi,

you can try like below,

Sum({<ITEMTYPE={'I-P','P-P','P'},Year={2017},Trans={'<>0'} >}Trans)

or

try this

Sum({\$<ITEMTYPE={'I-P','P-P','P'},Year={2017},Trans={"=sum(Trans)<>0"} >}Trans)

if above method not working then u can try

Sum({\$<ITEMTYPE={'I-P','P-P','P'},Year={2017},Trans-={0} >}Trans)

if still has issue then share the mock data and expected output. tks

3 Replies
Honored Contributor II

## Re: Set modifier with relational operator Not equal to 0

Hi,

you can try like below,

Sum({<ITEMTYPE={'I-P','P-P','P'},Year={2017},Trans={'<>0'} >}Trans)

or

try this

Sum({\$<ITEMTYPE={'I-P','P-P','P'},Year={2017},Trans={"=sum(Trans)<>0"} >}Trans)

if above method not working then u can try

Sum({\$<ITEMTYPE={'I-P','P-P','P'},Year={2017},Trans-={0} >}Trans)

if still has issue then share the mock data and expected output. tks

Contributor II

## Re: Set modifier with relational operator Not equal to 0

Why not

Sum({<ITEMTYPE={'I-P','P-P','P'},Year={2017},Trans-={'0'} >}Trans)?

New Contributor III

## Re: Set modifier with relational operator Not equal to 0

I actually gave your the wrong expression it should of been

Count({<ITEMTYPE={'I-P','P-P','P'},ServiceYear={2017}>}distinct ENCID)

So I tried the 2nd suggestion:

Count({\$<ITEMTYPE={'I-P','P-P','P'},ServiceYear={2017},Trans={"=sum(Trans)<>0"} >}distinct ENCID)

and it works perfect...it excludes ENCID's where the sum of Trans is equal to 0.00

Thanks so much!