topic simple Order by question in QlikView

simple Order by question

Thu, 10 Nov 2011 14:55:13 GMT

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?

Re: simple Order by question

jagannalla — Thu, 10 Nov 2011 15:02:36 GMT

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;

simple Order by question

Fri, 11 Nov 2011 07:17:19 GMT

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).

Re: simple Order by question

jagannalla — Fri, 11 Nov 2011 07:29:33 GMT

Use Qualify *

QUALIFY *;

Test2:

LOAD Product,

Date,

Quantity,

Customer

Resident Test1

Order By Date;

Drop Table Test1;

Re: simple Order by question

Fri, 11 Nov 2011 07:39:09 GMT

thanks !