Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

simple Order by question

Hi,

I'm new to QlikView and have a Load somewhat like this:


Test1:
LOAD Product,
Date,
Quantity,
Customer
FROM
QV_Date_Test.txt
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);


I want to Order by Date, and find in the Reference Manual that I have to use a resident table.
Based on my Load, what will be the next to write in the script to get this right?

1 Solution

Accepted Solutions
jagannalla
Valued Contributor III

Re: simple Order by question

Use Qualify *

QUALIFY *;

Test2:

LOAD Product,

Date,

Quantity,

Customer

Resident Test1

Order By Date;

Drop Table Test1;

4 Replies
jagannalla
Valued Contributor III

Re: simple Order by question

Use the below code it may helps you...

Test1:

LOAD Product,

Date,

Quantity,

Customer

FROM

QV_Date_Test.txt

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Test2:

LOAD Product,

Date,

Quantity,

Customer

Resident Test1

Order By Date;

Drop Table Test1;

Not applicable

simple Order by question

If I drop Table Test1, no data exists - Table Test2 is not there, (if I don't Drop Table Test1, I only have one Table (Test1), but then the number of records have been doubled).

jagannalla
Valued Contributor III

Re: simple Order by question

Use Qualify *

QUALIFY *;

Test2:

LOAD Product,

Date,

Quantity,

Customer

Resident Test1

Order By Date;

Drop Table Test1;

Not applicable

Re: simple Order by question

thanks !