Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
kruks123
New Contributor II

Pivot table sorting and highlighting top 5 rows from measures

Hi friends ,

I am very new to qlik Sense and was trying to get help from you for sorting my pivot table using measures coloumn. My data has trucks and the number of dec Units in them. I want to sort my table using DECRO. I could do it my total coloumns and not by decRo percentages.

it would be great help  me .

also wanted to highlight highest 5 rows with hightest units number in DECRO

THANKS AGAIN 18582F0E-7C93-442F-B1F4-8A92EC3E1DC9.jpeg

1 Reply
dilipranjith
Honored Contributor

Re: Pivot table sorting and highlighting top 5 rows from measures

Use rank function and background color to achieve it.

e.g. mark top 5 sales in red

Background color expression 

if(rank(sum(LineSalesAmount),CustomerCountry)<=5,red(),white())