Announcements
cancel
Showing results for
Did you mean:
Not applicable

## How to suppress Negitive Values

Dear All

 No Name Amt1 Commi 101 Sankar 100 200 101 Sankar -25 0 102 ram 200 100 102 ram -50 0

i wat to suppress Negitive values and Zero's

Regards

Sankar

1 Solution

Accepted Solutions
Employee

Hi Sankar,

You need to use the same set analysis in all three expressions, so the values are not even shown. So if Amt1 works with

`Sum({< Amt1 = {">0"} >} Amt1)`

Amt2 should work with

`Sum({< Amt1 = {">0"} >} Amt2)`

And likewise Commi

`Sum({< Amt1 = {">0"} >} Commi)`

Hope that helps.

Miguel

10 Replies
Partner - Specialist II

Hi, Sankar,

you can use the expression:

If(Sum(Amt1)>0,Sum(Amt1))

Greetings from Munich

Martina

EVACO GmbH

Luminary Alumni

Hi Sankar,

I am not sure which chart object you are using. However you can use something like this...

If( Amount1 <= 0, White( ) )

You can change the text color to white. So the users wont see these values.

Please post a QV document as sample if you need more help.

Cheers - DV

Partner - Specialist II

Hi, Sankar,

you can use in my if-statement followinmg else-statements:

If(Sum(Amt1)>0,Sum(Amt1),0)

If(Sum(Amt1)>0,Sum(Amt1),'')

If(Sum(Amt1)>0,Sum(Amt1),NULL())

Employee

Hi,

I'd use a set analysis instead to make the chart perform faster avoiding the use of conditionals:

`Sum({< Amt1 = {">0"} >} Amt1)`

Hope that helps.

Miguel

Not applicable
Author

Thx to all

all Queries are working fine.My source like below

 No Name Amt1 Amt2 Commi 101 Sankar 100 500 200 101 Sankar -25 25 0 102 ram 200 300 100 102 ram -50 50 0

but i want to display as below

 No Name Amt1 Amt2 Commi 101 Sankar 100 500 200 102 ram 200 300 100

suppress and delete the row.

Regards

Sankar

Luminary Alumni

Hi Sankar,

Have you tried Miguel's Set Analysis expression? That should work in your requirement.

Cheers - DV

Not applicable
Author

Hi

I tried Miguel's Set Analysis expression but it is displaying as below

 No Name Amt1 Amt2 Commi 101 Sankar 100 500 200 101 Sankar 0 25 0 102 ram 200 300 100 102 ram 0 50 0

my target is as below

 No Name Amt1 Amt2 Commi 101 Sankar 100 500 200 102 ram 200 300 100
Employee

Hi Sankar,

You need to use the same set analysis in all three expressions, so the values are not even shown. So if Amt1 works with

`Sum({< Amt1 = {">0"} >} Amt1)`

Amt2 should work with

`Sum({< Amt1 = {">0"} >} Amt2)`

And likewise Commi

`Sum({< Amt1 = {">0"} >} Commi)`

Hope that helps.

Miguel

Champion II

In dimension take No, Name

in first expression take

sum(if(Amt1>0,Amt1))

in second exp

sum(if(Amt1>0,Amt2))

in third

exp

sum(if(Amt1>0,Commi))

hope this helps

Sunil Chauhan
Community Browser