topic Re: Order by problem in QlikView

Order by problem

Anonymous — Mon, 21 Jan 2013 09:44:03 GMT

Hi,

I need to order a qvd file by two fields, but it seems impossible. I'm sure, I'm making some mistakes but I don't know where.

See below:

MYTABLE:

LOAD MyField,

MyfieldSequence

FROM

[..\..\..Myfolder\Mytable.qvd]

(qvd) ;

Mytable1:

NoConcatenate

load *, 1 as newflag

resident MYTABLE order by Myfield asc, MyfieldSequence desc;

drop table MYTABLE;

It's very simple, but I don't see my data listed in the right order.

Help please !!

Re: Order by problem

Mon, 21 Jan 2013 09:51:15 GMT

Get thru the properties "Sort" and tick the sort by load order "original "

Christian

Re: Order by problem

Anonymous — Mon, 21 Jan 2013 09:58:54 GMT

Hi Christian, thanks for your answer.

I would sort data in the script without using sort properties tab in my objects.

Is it possible ?

Re: Order by problem

er_mohit — Mon, 21 Jan 2013 11:43:17 GMT

try this

firstly load your table

MYTABLE:

LOAD MyField,

MyfieldSequence

FROM

[..\..\..Myfolder\Mytable.qvd]

(qvd) ;

load

MyField,

MyfieldSequence

resident MYTABLE

order by Myfield asc, MyfieldSequence desc;

load

MyField,

MyfieldSequence

resident MYTABLE;

drop table MYTABLE;

i can't get you exactly if you attached data file then i understand clearly....

Re: Order by problem

Mon, 21 Jan 2013 12:43:49 GMT

try this, hope it helps you.

tab1:

LOAD myfield,

myfieldseq

FROM

(ooxml, embedded labels, table is Sheet1);

tab2:

NoConcatenate

load *, RecNo() as newflag

resident tab1 order by myfield asc, myfieldseq desc ;

drop table tab1;

Re: Order by problem

Mon, 21 Jan 2013 13:45:28 GMT

Yes I understand,

It seems you sort is right but to see how exactly it is loaded you have to display and sort it by original load order.

When then you checked it is well loaded you are sure you can work in your script on a table sorted as you want. For example, you can you previous, peek...

Christian