Discussion Board for collaboration related to QlikView App Development.
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.
Go to Solution.
Maybe use a background color attribute expression like
rank(total if(sum(PERC) <> '0',sum(PERC))) <= 2,LightGreen(),
If(rank(total if(sum(PERC) <> '0',-sum(PERC))) <=2 , lightred())
View solution in original post