Highlighting top 5 values in qliksense table

[Anonymous]

Hi, I am new to qliksense , I was not able to create an expression of background color for top 5 values in the coloumn. Can someone help me with the same . I want to highlight top 5 Rounits

[bramkn]

if you have it sorted on the values and the top5 is always at the top you can use something like if(match(rowno(),1,2,3,4,5),red())

[sunny_talwar]

What is the expression behind Ro Units or is this a field?

[Anonymous]

Ya but I wanted my table to be sorted by highest ro percentage column. And highlight top5 rounits. All are coloumns directly from Except percentages

[Anonymous]

It’s a field for RO UNITS , the ro percentage is rounits / grand total.

[sunny_talwar]

May be just do this as a color expression for all dimensions and measures in your chart

If(Rank([RO UNITS]) < 6, Red())

[Anonymous]

It shows error grabbae after and ranks 1 to all when I use same field to create new coloumn .

[sunny_talwar]

Would you be able to share your app or a sample app where you are having this issue?

[Anonymous]

Ya give me 5 mins I’ll upload the app

[Anonymous]

Check this I want to only highlight top 5 Ro units and chart to be sorted as per % r

I was unable to attach ,qvf file here so