Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kruks123
New 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 (4)
1 Solution

Accepted Solutions

Re: Highlighting top 5 values in qliksense table

Can you give this a shot

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

 

12 Replies
Partner
Partner

Re: Highlighting top 5 values in qliksense table

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

Re: Highlighting top 5 values in qliksense table

What is the expression behind Ro Units or is this a field?
kruks123
New Contributor II

Re: Highlighting top 5 values in qliksense table

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
Highlighted
kruks123
New Contributor II

Re: Highlighting top 5 values in qliksense table

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

Re: Highlighting top 5 values in qliksense table

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

If(Rank([RO UNITS]) < 6, Red())
kruks123
New Contributor II

Re: Highlighting top 5 values in qliksense table

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

Re: Highlighting top 5 values in qliksense table

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

Re: Highlighting top 5 values in qliksense table

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

Re: Highlighting top 5 values in qliksense table

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