topic Re: Load top n records in QlikView

Load top n records

Fri, 26 Dec 2014 11:57:45 GMT

How do i load only top 5 records in qlikvew?

Re: Load top n records

MK_QSL — Fri, 26 Dec 2014 12:06:15 GMT

Test:

Load Customer, Sales From TableName;

Left Join

Load Customer, SUM(Sales) as TotalSales Resident Test Group By Customer;

Noconcatenate

Final:
Load Customer, TotalSales Resident Test Where RowNo() <=5 Order By TotalSales Desc;

Drop Table Test;

Re: Load top n records

vivek_niti — Sat, 27 Dec 2014 05:27:57 GMT

Hi,

Use the keyword FIRST before LOAD.

tab1:

FIRST 5 LOAD *

FROM ...........

Re: Load top n records

rajeshvaswani77 — Sat, 27 Dec 2014 05:44:45 GMT

Hi Asma,

Use

table1:

FIRST 5 LOAD *

FROM ...........Tablename order by fieldname

Thanks,

Rajesh Vaswani

Re: Load top n records

Sat, 27 Dec 2014 05:55:21 GMT

JUST ADD

First N to a LOAD or SELECT statement , where N is the first number of records you want to load .

Re: Load top n records

alkesh_sharma — Sat, 27 Dec 2014 06:16:22 GMT

Try this:

ON the script editor, select Debug -> limit load -> 5 -> start

Re: Load top n records

its_anandrjs — Sat, 27 Dec 2014 06:37:11 GMT

Hi,

For finding Top 5 in the front end try this

Assume this example

Source:
LOAD * Inline [
Centers,Sales
A,98521
B,65823
C,32581
D,1587
E,12635
F,8426
G,12563
H,2569
I,78451
J,25638
K,45821
L,15896
M,1263
N,25874
O,7845
P,12589
];

Dim:- =if( Aggr(Rank(Sum(Sales)) <= 5,Centers),Centers)
Expre:- Sum(Sales)

Or In script you can

Source:
LOAD * Inline [
Centers,Sales
A,98521
B,65823
C,32581
D,1587
E,12635
F,8426
G,12563
H,2569
I,78451
J,25638
K,45821
L,15896
M,1263
N,25874
O,7845
P,12589
];
Left Join
Load Centers, SUM(Sales) as Total Resident Test Group By Centers;
Noconcatenate
First 5
Final:
Load Centers, Total Resident Source
Order By TotalSales desc;
Drop Table Source;

Regards,

Anand

Re: Load top n records

Harish_zreddy — Sat, 13 Aug 2022 13:36:04 GMT

Hi,

If i use this FIRST 5 LOAD * I am getting qvx file error. If there is only one table, it is executing but if there are more than one table it is not executing. Can you please provide the solution for this.