topic Re: Exclude zero and negative values in QlikView

Exclude zero and negative values

Anonymous — Fri, 05 Jan 2018 05:25:27 GMT

How to Exclude zero and negative values in the Expression

Re: Exclude zero and negative values

PrashantSangle — Fri, 05 Jan 2018 05:32:32 GMT

In expression try like

if(USD>0,Sum(USD))

Regards,

Re: Exclude zero and negative values

neha_shirsath — Fri, 05 Jan 2018 05:36:17 GMT

You can create flag in script like-

if(isnull(USD) or USD<0,1,0) as flag

ANd use this flah in your expression like-

sum({<Flag= {0}>}USD)

Re: Exclude zero and negative values

vishalmanu — Fri, 05 Jan 2018 05:56:27 GMT

HI,

You can write a simple if condition in your expression as below

if(USD>0,Sum(USD))

Re: Exclude zero and negative values

Anonymous — Fri, 05 Jan 2018 05:56:35 GMT

Can some one help me, result should be like this in the screenshot, attached source for your reference.

Re: Exclude zero and negative values

Anil_Babu_Samineni — Fri, 05 Jan 2018 06:05:51 GMT

Perhaps this? I didn't test due to there is no S/W in my machine

Sum({<[Cus ID] = {"=Sum(USD)>0"}>} USD)

Re: Exclude zero and negative values

PrashantSangle — Fri, 05 Jan 2018 06:09:58 GMT

did you try any of the above solution?

Re: Exclude zero and negative values

neha_shirsath — Fri, 05 Jan 2018 06:13:24 GMT

Find the attached file.

Re: Exclude zero and negative values

vishalmanu — Fri, 05 Jan 2018 06:13:34 GMT

Hi,

You can try using the expression that i have posted above. its working and i am able to get the result as per the screenshot posted by you. Or you can try using the expression posted by Anil Babu. Both the expressions will give you the same output.

Re: Exclude zero and negative values

Anonymous — Fri, 05 Jan 2018 06:47:34 GMT

Thanks, the below one is working in background expression

if(USD>0,USD) as Flag

Re: Exclude zero and negative values