How to suppress Negitive Values

[#1]

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

help me please.......................

Regards

Sankar

[brenner_martina]

Hi, Sankar,

you can use the expression:

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

Greetings from Munich

Martina

EVACO GmbH

[IAMDV]

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

[brenner_martina]

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())

[Miguel_Angel_Baeyens]

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

[#6]

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

[IAMDV]

Hi Sankar,

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

Cheers - DV

[#8]

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

[Miguel_Angel_Baeyens · Accepted solution]

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

[SunilChauhan]

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