Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 - Specialist
Partner - Specialist

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
Not applicable
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
Anonymous
Not applicable
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())
Anonymous
Not applicable
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?
Anonymous
Not applicable
Author

Ya give me 5 mins I’ll upload the app
Anonymous
Not applicable
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