topic What is Load Order in QlikView? in QlikView

What is Load Order in QlikView?

jblomqvist — Thu, 23 Apr 2015 10:11:13 GMT

Hello,

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

Re: What is Load Order in QlikView?

Gysbert_Wassenaar — Thu, 23 Apr 2015 10:16:24 GMT

Take this load as example:

LOAD * INLINE [

FieldA

];

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.

Re: What is Load Order in QlikView?

jblomqvist — Thu, 23 Apr 2015 11:03:15 GMT

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?

Re: What is Load Order in QlikView?

Gysbert_Wassenaar — Thu, 23 Apr 2015 11:12:02 GMT

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

];

T2:

Noconcatenate

LOAD FieldA, FieldA as FieldB

Resident T1

ORDER BY FieldA desc;

DROP TABLE T1;

Re: What is Load Order in QlikView?

maxgro — Thu, 23 Apr 2015 11:12:17 GMT

try this to change sort load order

load * inline [

field

]

;

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

DROP Table a;