topic Re: Color Coding in Dimension based on expression value in QlikView

Color Coding in Dimension based on expression value

Tue, 18 Dec 2012 04:45:05 GMT

Hi All,

I am trying to implement a color coding using the "Background Color" in the dimension. My requirement is to code the dimension value based on the total(expression).

Example:

Dimension	Expression=count(ID)	Color
A	50	GREEN
B	20	YELLOW
C	30	LIGHT GREEN
D	100	RED
E	80	BLUE

I can't directly code if(Dimension = 'D' , RGB(-,-,-) ) because the expression value varies. All I want is the highest should be RED,next BLUE, next GREEN and so on.....

Can anyone please suggest something??

Thanks for your help

Re: Color Coding in Dimension based on expression value

sujeetsingh — Tue, 18 Dec 2012 05:03:28 GMT

Asumme is there are lakhs of record then what will happen i think the dictionary of color will come to end....

try to set some criteria and then easily we can use colors.

Re: Color Coding in Dimension based on expression value

Tue, 18 Dec 2012 06:39:42 GMT

Hi Sardar,

I do have thousands of record but the distinct dimension values are less than 10, so if I know how to color code based on my requirement above I would be okay.

Thanks for your reply.

Re: Color Coding in Dimension based on expression value

sujeetsingh — Tue, 18 Dec 2012 07:03:42 GMT

Hi Yaman,

Go to The expression and clik on the + sign of expression....

There go on Background color..

and write this code,,,

=if(rank([Count(ID)])=1,RED(),

if(rank([Count(ID)])=2,Green(),

if(rank([Count(ID)])=3,Yellow(),

if(rank([Count(ID)])=4,White(),Blue()))))

Please set the colors according to your requirement,

Re: Color Coding in Dimension based on expression value

Tue, 18 Dec 2012 07:17:02 GMT

Hi Sardar,

Thanks for replying. I actually used the expression below , but its only working for rank 1 and 2. Its not working for rank 3 and above. any idea what could be wrong.

Here is the expression:

=if(rank(count([Sl. No]))= 1,Blue(),

if(rank(count([Sl. No]))= 2, rgb(255,0,0),

if(rank(count([Sl. No]))= 3, Yellow())))

Thanks a lot for your help.

Re: Color Coding in Dimension based on expression value

sujeetsingh — Tue, 18 Dec 2012 07:20:18 GMT

=if(rank(count([Sl. No]))= 1,Blue(),

if(rank(count([Sl. No]))= 2, rgb(255,0,0),

if(rank(count([Sl. No]))= 3, Yellow(), white())))

Add the white() color code at last hope it work..

And please update the discussion with correct or helpful answer status,which ever you think and satisfied.

Re: Color Coding in Dimension based on expression value

Tue, 18 Dec 2012 08:59:01 GMT

Thank you Son of Sardar.

Re: Color Coding in Dimension based on expression value

sujeetsingh — Tue, 18 Dec 2012 09:01:55 GMT

It just like helping one with the faith that when i will be in need some other or same will help mee.

You are welcome.

Can i know from where you are ...?

And Firm you are working with..??

It seems that it is much personal ..but if possible then tell else no issue