Pivot table sorting and highlighting top 5 rows from measures

[Anonymous]

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

‌

[dplr-rn]

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