Discussion board where members can get started with Qlik Sense.
Logics to color: the major in green and the worst in red (with the shades of colour in the centre).
Now i used :ColorMix1( rank(total column(1))/noofrows(TOTAL) , lightred(),LightGreen())
But is not correct to my Logics to color: the major in green and the worst in red (with the shades of colour in the centre).
I attach the qliksense app and the picture of what I want to replicate with qliksense.
Go to Solution.
Hello Anna Maria
May be this way :
ColorMix1( hrank(total column(1))/NoOfColumns(TOTAL) , lightgreen(),lightred())
replace renk by hrank and NoofRows by NoOfColumns
See below and chek if it's OK with desired outpout :
Yes, Now it works. Thank you Bruno
Can You Help me about this post too?