# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for
Did you mean:
Contributor III

## Exclude zero and negative values

How to Exclude zero and negative values in the Expression

1 Solution

Accepted Solutions

In expression try like

if(USD>0,Sum(USD))

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
9 Replies

In expression try like

if(USD>0,Sum(USD))

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Specialist

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)

Creator

HI,

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

if(USD>0,Sum(USD))

Contributor III
Author

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

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

did you try any of the above solution?

Great dreamer's dreams never fulfilled, they are always transcended.
Specialist

Find the attached file.

Creator

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.

Contributor III
Author

Thanks, the below one is working in background expression

if(USD>0,USD) as Flag

Community Browser