Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
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
Labels (4)
2 Replies
Luminary
Luminary

Re: Highlighting top 5 values in qliksense table

Try

If(Rank(Expression)<=5, LightRed())

Replace "Expression" with whatever expression you are using in that particular column.

Help page on Rank()

Partner
Partner

Re: Highlighting top 5 values in qliksense table

Try, if (rank(UrMeasure,UrDimension)<=5, green()) 

 

Per analogy :

Capture.PNG