topic Re: Color coding based on rank in pivot table in QlikView

Color coding based on rank in pivot table

mightyqlikers — Mon, 13 Jun 2016 08:34:15 GMT

Dear team,

please find the attached.

and in that i want to give the color of max 2 of sum(perc) green and min 2 of sum(perc) as red as per the rank.

for example in CA column rank 1&2 should get green and 4&5 should get red like wise for all the columns.

please help

swuehl — Mon, 13 Jun 2016 09:37:47 GMT

Maybe use a background color attribute expression like

=If(

rank(total if(sum(PERC) <> '0',sum(PERC))) <= 2,LightGreen(),

If(rank(total if(sum(PERC) <> '0',-sum(PERC))) <=2 , lightred())

)

mightyqlikers — Mon, 13 Jun 2016 09:42:46 GMT

Perfecto stephen.

Thank you.