How to select top 10 values from a field

[Shumaila]

in this table, I want the top 10 values of Pen.

The output should be like 

[sergio0592]

Hi,

Something like

tab1:
LOAD * INLINE [
Pen
-69
-70
-93
-51
-57
-61
-72
-64
-60
-71
-70
-78
-54
-65
-72
-87
-74
-74];

Tab2:
load Pen, RowNo() 
Resident tab1
where RowNo() <9;

drop table tab1;

[Kushal_Chawda · Accepted solution]

@Shumaila  Is it similar to below thread?

https://community.qlik.com/t5/New-to-QlikView/Min-values-in-qlikview-table/m-p/1740266#M392563

[Brett_Bleess]

Going to add one other item as was not sure exactly what you were trying to do, so this one may be closer:

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684

If one of the others did work, we would appreciate it if you would close the thread by using the Accept as Solution button on the post(s) that did help.

Regards,
Brett

[Shumaila]

Thank you @Kushal_Chawda 

it worked for me!

[Shumaila]

Thank you @Brett_Bleess, this problem has been solved!