Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kruks123
Contributor II
Contributor II

Highlighting top 5 values in qliksense table

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
Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

Can you give this a shot

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

 

View solution in original post

12 Replies
bramkn
Partner
Partner

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?
kruks123
Contributor II
Contributor II
Author

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
kruks123
Contributor II
Contributor II
Author

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())
kruks123
Contributor II
Contributor II
Author

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?
kruks123
Contributor II
Contributor II
Author

Ya give me 5 mins I’ll upload the app
kruks123
Contributor II
Contributor II
Author

Check this I want to only highlight top 5 Ro units and chart to be sorted as per % rERROR1.PNGerror2.PNGerror3.PNG

 

 

I was unable to attach ,qvf file here so