topic How to select top 10 values from a field in QlikView

How to select top 10 values from a field

Shumaila — Wed, 25 Nov 2020 16:16:04 GMT

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

The output should be like

Re: How to select top 10 values from a field

sergio0592 — Tue, 01 Sep 2020 19:50:13 GMT

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;

Re: How to select top 10 values from a field

Kushal_Chawda — Tue, 01 Sep 2020 20:17:01 GMT

@Shumaila Is it similar to below thread?

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

Re: How to select top 10 values from a field

Brett_Bleess — Tue, 15 Sep 2020 18:28:12 GMT

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

Re: How to select top 10 values from a field

Shumaila — Wed, 16 Sep 2020 05:54:50 GMT

Thank you @Kushal_Chawda

it worked for me!

Re: How to select top 10 values from a field

Shumaila — Wed, 16 Sep 2020 05:56:47 GMT

Thank you @Brett_Bleess, this problem has been solved!