topic Re: How to Color the Columns??? in QlikView

How to Color the Columns???

Wed, 23 Jul 2014 02:41:17 GMT

Hi,

I got a column like below where I want to color If Actual is more than plan green or if plan more than actual red

I used below query in "actual's" background color, it worked but if you notices below table there are empty column and "N/A" in actual column where I want make both white and if it's "N/A" I want to display that on my straight table. please help me on this... how do I do that?

if(Avg([Plan])> Avg([Actual),RGB(255,99,71),RGB(50,205,50))

If Plan is more than Actual = RED or If Actual is more than Plan = GREEN

and if the cell has the letter "NA" it should read the letter "NA" and the cell should be = WHITE

Plan	Actual
80%	45%
50%	50%
60%	N/A
100%	100%
0%	0%
100%	100%
90%	90%
-	-
100%	N/A
100%	70%

Re: How to Color the Columns???

sujeetsingh — Wed, 23 Jul 2014 04:08:42 GMT

If plan is your field then write nested if , as click on expression'+' sign then comes option of Background colour

and then write your condition

Re: How to Color the Columns???

sujeetsingh — Wed, 23 Jul 2014 04:11:07 GMT

See this sample please

Re: How to Color the Columns???

vikasmahajan — Wed, 23 Jul 2014 04:22:38 GMT

you can use visual cuves with conditions and colour which you required from presentation tab

Hope this helps you.

Vikas

Re: How to Color the Columns???

PrashantSangle — Wed, 23 Jul 2014 04:26:28 GMT

Hi,

Try this in Background Color Expression.

if((Actual)='NA',rgb(0,0,0),if(if(Avg([Plan])> Avg([Actual),RGB(255,99,71),RGB(50,205,50))))

Regards,

Re: How to Color the Columns???

Thu, 24 Jul 2014 02:07:45 GMT

thank you!

but if you have notice my post, I said that I want to add 3 color

such as;

1. if <= 50 green

2. if >50 red

3. if 'NA' white

Re: How to Color the Columns???

Anonymous — Thu, 24 Jul 2014 02:23:15 GMT

Hi,

Try below,

If(Actual='NA', RGB(0,0,0), If(Avg([Plan])>Avg([Actual), RGB(255,99,71), RGB(50,205,50)))

Re: How to Color the Columns???

Thu, 24 Jul 2014 02:59:17 GMT

thanks!

I want to can I can process the query in the straight chat? coz in the straight it shows 'NA' as '-'

and its only showing RED and GREEN. please find the QVD in the attachment

Re: How to Color the Columns???

Anonymous — Thu, 24 Jul 2014 03:21:02 GMT

Hi,

Try below script instead.

If(Avg([Plan])>Avg([Actual]), RGB(255,99,71),

If(Avg([Plan])<=Avg([Actual]), RGB(50,205,50), White()))

Re: How to Color the Columns???

Thu, 24 Jul 2014 03:27:03 GMT

Thank you so much!!!