topic Re: Color is not shown correctly!! in QlikView

Color is not shown correctly!!

nikhilgarg — Fri, 10 Oct 2014 08:03:50 GMT

Hello,

I have attached a samplpe of application. In that i am using expression to color the values above and below threshhold as RED.

And in between threshhold as BLACK.

=if(Sum(Price) > (Avg(Price) + Avg(Price)*0.02) , RGB(255,0,0),

if(Sum(Price) < (Avg(Price) - Avg(Price)*0.02) , RGB(255,0,0),

if(Sum(Price) >= ((Avg(Price) - Avg(Price)*0.02) and (Sum(Price) <= (Avg(Price) + Avg(Price)*0.02) , RGB(0,0,0),

)))

But same is not happening . Please see...

Re: Color is not shown correctly!!

salto — Fri, 10 Oct 2014 08:16:24 GMT

Hello Nikhil,

RGB is working well. I think that the problem is that the condition

if(Sum(Price) >= ((Avg(Price) - Avg(Price)*0.02) and (Sum(Price) <= (Avg(Price) + Avg(Price)*0.02)

is never TRUE and that is the reason why it does not show black.

Hth.

Re: Color is not shown correctly!!

PrashantSangle — Fri, 10 Oct 2014 08:23:19 GMT

Hi,

Try this

=if(Sum(Price) > (Avg(Price) + Avg(Price)*0.02) , RGB(255,0,0),

if(Sum(Price) < (Avg(Price) - Avg(Price)*0.02) , RGB(255,0,0), RGB(0,0,0),

))

Remove this condition

if(Sum(Price) >= ((Avg(Price) - Avg(Price)*0.02) and (Sum(Price) <= (Avg(Price) + Avg(Price)*0.02),

Regards

Re: Color is not shown correctly!!

nikhilgarg — Fri, 10 Oct 2014 08:25:36 GMT

Hey,

it is also not working.

What should i do ??

Thanks

Re: Color is not shown correctly!!

antoniotiman — Fri, 10 Oct 2014 08:26:35 GMT

Hi NiKhil,

I correct espression [- ',' + 2')'], but I don't know if it work well. I see only red.

Regards

Re: Color is not shown correctly!!

nikhilgarg — Fri, 10 Oct 2014 08:45:01 GMT

I cannot open your qvw.Can you tell me here.

Thanx

Re: Color is not shown correctly!!

antoniotiman — Fri, 10 Oct 2014 08:57:42 GMT

Re: Color is not shown correctly!!

sorrakis01 — Fri, 10 Oct 2014 09:00:21 GMT

Yes,

the example of Antonio works well.

=if((Sum(Price) > (Avg(Price) + Avg(Price)*0.02)) , RGB(10,410,0), if(Sum(Price) < (Avg(Price) - Avg(Price)*0.02) , RGB(25,80,100),

if(Sum(Price) >= (Avg(Price) - Avg(Price)*0.02) and Sum(Price) >= (Avg(Price) + Avg(Price)*0.02), RGB(0,255,80)

)))

I changed the values of RGB to demostrate it

Regards

JAG

Re: Color is not shown correctly!!

PrashantSangle — Fri, 10 Oct 2014 09:04:13 GMT

Hi,

There is bracket missing in your expression.

You can correct your expression by giving proper bracket closing

Try Like

=if(Sum(Price) > (Avg(Price) + Avg(Price)*0.02) , RGB(255,0,0),

if(Sum(Price) < (Avg(Price) - Avg(Price)*0.02) , RGB(255,0,0),

if(Sum(Price) >= ((Avg(Price) - Avg(Price)*0.02)) and (Sum(Price) <= (Avg(Price) + Avg(Price)*0.02)) , RGB(0,0,0),

)))

or modify it like

=if(Sum(Price) >= ((Avg(Price) - Avg(Price)*0.02)) and (Sum(Price) <= (Avg(Price) + Avg(Price)*0.02)),RGB(0,0,0),
if(Sum(Price) > (Avg(Price) + Avg(Price)*0.02),RGB(255,0,0),
if(Sum(Price) < (Avg(Price) - Avg(Price)*0.02) , RGB(255,255,255),
)))

you can try this also

=if(Sum(Price) > (Avg(Price) + Avg(Price)*0.02) , RGB(255,0,0),
if(Sum(Price) < (Avg(Price) - Avg(Price)*0.02) , RGB(255,255,255), RGB(0,0,0)
))

and check your logic which you are comparing in if. I am not sure that it is working proper.

Kind Regards

Re: Color is not shown correctly!!

nikhilgarg — Fri, 10 Oct 2014 09:04:19 GMT

HEy,

It is still not working. I mean , I want the values above High threshhold and below Low threshhold as RED and between High threshhold and LowThreshhold as BLACK. PRice is my field.

How to do this ???

Re: Color is not shown correctly!!

nikhilgarg — Fri, 10 Oct 2014 09:05:06 GMT

HEy,

It is not working well.

I mean , I want the values above High threshhold and below Low threshhold as RED and between High threshhold and LowThreshhold as BLACK. PRice is my field.

How to do this ???

Re: Color is not shown correctly!!

Fri, 10 Oct 2014 09:10:42 GMT

Hi Nikhil,

Look at the attached qvw.

The first 2 conditions you have in the color expression are never true. you can see clearly in the chart.

thats why always 3rd conditrion is true and it remains the same color, you might have to relook at the conditions mentioned in color expression.

Thanks,

Shruthi Reddy

Re: Color is not shown correctly!!

nikhilgarg — Fri, 10 Oct 2014 09:17:56 GMT

HEy,

I cannot open your qvw. Can you tell me here what to do.

Thanks

Re: Re: Color is not shown correctly!!

Fri, 10 Oct 2014 09:22:54 GMT

if you look at the attached image, its a graph with two more expressions added in your qvw.

so the "(Avg(Price) + Avg(Price)*0.02 )" is always greater than sum(Price) and

"(Avg(Price) - Avg(Price)*0.02 )" is always less than sum (price)

but the expression you used for color

=if(Sum(Price) > (Avg(Price) + Avg(Price)*0.02 ), RGB(255,0,0),

if(Sum(Price) < (Avg(Price) - Avg(Price)*0.02 ), RGB(255,0,0),

if((Sum(Price) >= (Avg(Price) - Avg(Price)*0.02) and Sum(Price) <= (Avg(Price) + Avg(Price)*0.02)) ,rgb(0,0,0))))

the first two conditions are never true so you alwasy get a single color.

Thanks,

Shruthi Reddy

Re: Color is not shown correctly!!

antoniotiman — Fri, 10 Oct 2014 09:25:57 GMT

Re: Re: Color is not shown correctly!!

nikhilgarg — Fri, 10 Oct 2014 09:26:20 GMT

Hey,

I want to compare the Price field with High Threshhold((Avg(Price) + Avg(Price)*0.02 )) and Low Threshhold((Avg(Price) - Avg(Price)*0.02 )) and put color accordingly.

What should i do ??

Re: Color is not shown correctly!!

nikhilgarg — Fri, 10 Oct 2014 09:32:03 GMT

Hey,

thanks a lot for this. But what does TOTAL makes a difference ??

I was using Sum(Price)/Count(Price) for average . Was that wrong ??

Please tell

Thanks

Re: Color is not shown correctly!!

antoniotiman — Fri, 10 Oct 2014 09:41:54 GMT

I simplify.

You need TOTAL to get all dimension values.

Regards,

Antonio