Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
mightyqlikers
Contributor III

Color coding based on rank in pivot table

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        

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Color coding based on rank in pivot table

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())

)

View solution in original post

2 Replies
MVP
MVP

Re: Color coding based on rank in pivot table

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())

)

View solution in original post

mightyqlikers
Contributor III

Re: Color coding based on rank in pivot table

Perfecto  stephen.

Thank you.