Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

top 10

Guys Hello,

i want to get the top 10 of my rows based on the field sla inter

Capture.PNG

I did that :

Capture.PNG

Capture.PNG

but i still get all the rows

any idea please

4 Replies
YoussefBelloum
Champion
Champion

Hi,

you can do this on your expression (remove the customized sorting):

=if(rank(sum(SLA_INTERM),4)<=10, your_expression)


like this you will have your TOP 10 expression value depending on the SLA_INTERM

zhadrakas
Specialist II
Specialist II

try to use the Limit on presentation tab

master_student
Creator III
Creator III
Author

Thanks but both solutions didn't work

YoussefBelloum
Champion
Champion

Can you attach sample dataset ?