topic question about load order in Qlik Learning Discussions

question about load order

Anonymous — Tue, 17 Mar 2015 13:18:29 GMT

Hi,

I'd like to change the order of values in the field Brand while loading the data from the source table. I need to set an alphabetical order of brands while loading the field Brand. How is that possible?

Larisa

Re: question about load order

rubenmarin — Tue, 17 Mar 2015 14:00:25 GMT

Hi Larisa, in the Sort tab you can set the order of any chart.

Anyway, if you want the load order in QV to be by Brand you can do:

Excel:

LOAD Brand,

[Cost RUB],

F3,

FROM

[.\brand_data2.xlsx]

(ooxml, embedded labels, table is data);

Data:

NoConcatenate LOAD * Resident Excel Order By Brand;

DROP table Excel;

Re: question about load order

Anonymous — Tue, 17 Mar 2015 15:34:20 GMT

I did as suggested. Then I created a list-box and set the load order for this list-box. But I see that the load order is not alphabetic. See the file attached.

Re: question about load order

rubenmarin — Tue, 17 Mar 2015 15:38:58 GMT

OK, as it is the same field, the loading sort order for Brand is set in the first load, you can try with:

Source1:

LOAD Brand as Brand_Orig,

[Cost RUB]

FROM

.\brand_data2.xlsx

(ooxml, embedded labels, table is data)

;

Data1:

NoConcatenate LOAD Brand_Orig as Brand, [Cost RUB] Resident Source1 Order By Brand_Orig

;

DROP table Source1;

This way the load order of Brand_Orig don't mess with the load order of Brand.

Re: question about load order

awhitfield — Tue, 17 Mar 2015 15:42:03 GMT

Hi Larisa,

you list box is set to load order, set it to Text A-Z

Andy