topic Re: Color Indications on new column. in QlikView

Color Indications on new column.

MuraliPrasath — Fri, 22 May 2015 15:42:55 GMT

Hi QV Team,

I've Total License and Used License column. I need one more column indicates colors.

Ex:- If my Used License is consumed 50% of the total License then GREEN Color.

If 80% Consumed then YELLOW Color.

If 100% Consumed then RED Color.

maxgro — Fri, 22 May 2015 16:12:25 GMT

in a straighjt table you can try to add an expression ( '' )

and in background color

if(column(2) = column(1), rgb(255,0,0),

if(column(2) >= column(1)*0.8, yellow(),

if(column(2) >= column(1)*0.5, rgb(0,255,0),

anothercolor

))))

you have to modify my example expression with your column and also change the math and color

Anonymous — Fri, 22 May 2015 18:39:07 GMT