# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Tags (3)
Labels (4)

• ### top5

1 Solution

Accepted Solutions
MVP

## Re: Highlighting top 5 values in qliksense table

Can you give this a shot

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

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

MVP

## Re: Highlighting top 5 values in qliksense table

What is the expression behind Ro Units or is this a field?
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
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.
Highlighted
MVP

## 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())
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 .
MVP

## 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?
New Contributor II

## Re: Highlighting top 5 values in qliksense table

Ya give me 5 mins I’ll upload the app
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 % r

I was unable to attach ,qvf file here so