topic Re: How to suppress Negitive Values in QlikView

How to suppress Negitive Values

Fri, 16 Dec 2011 10:11:22 GMT

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

How to suppress Negitive Values

brenner_martina — Fri, 16 Dec 2011 10:20:22 GMT

Hi, Sankar,

you can use the expression:

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

Greetings from Munich

Martina

EVACO GmbH

How to suppress Negitive Values

IAMDV — Fri, 16 Dec 2011 10:21:39 GMT

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

How to suppress Negitive Values

brenner_martina — Fri, 16 Dec 2011 10:24:08 GMT

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

Re: How to suppress Negitive Values

Miguel_Angel_Baeyens — Fri, 16 Dec 2011 10:27:53 GMT

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

How to suppress Negitive Values

Fri, 16 Dec 2011 10:50:36 GMT

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

How to suppress Negitive Values

IAMDV — Fri, 16 Dec 2011 11:00:19 GMT

Hi Sankar,

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

Cheers - DV

How to suppress Negitive Values

Fri, 16 Dec 2011 11:07:05 GMT

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

Re: How to suppress Negitive Values

Miguel_Angel_Baeyens — Fri, 16 Dec 2011 11:09:52 GMT

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

How to suppress Negitive Values

SunilChauhan — Fri, 16 Dec 2011 11:20:58 GMT

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

How to suppress Negitive Values

Fri, 16 Dec 2011 11:26:21 GMT

Thx for your reply.