What is Load Order in QlikView?

[jblomqvist]

Hello,

Does anyone have an example of what is a Load Order in Qlikview?

[Gysbert_Wassenaar · Accepted solution]

Take this load as example:

LOAD * INLINE [

FieldA

B

Z

A

];

The Load Order of the values of FieldA is first B, then Z and finally A. The A-Z text sort order of those same values is A, B, Z. So in this case the load order is different than the A-Z text sort order.

[jblomqvist]

Thank you Gysbert, so if I wanted to change the load order in the script I could use Order By maybe?

Is there other techniques?

[Gysbert_Wassenaar]

You can use Order By to change the order, but you'll have to rename the field. Try the example below and after reloading add two listboxes for FieldA and FieldB and set the sort order of both to Load Order.

T1:

LOAD * INLINE [

FieldA

B

Z

A

];

T2:

Noconcatenate

LOAD FieldA, FieldA as FieldB

Resident T1

ORDER BY FieldA desc;

DROP TABLE T1;

[maxgro]

try this to change sort load order

a:

load * inline [

field

a

b

c

]

;

b: NoConcatenate load field as field1  Resident a order by field desc;

DROP Table a;