Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

larisa_filonova
Not applicable

question about load order

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

1 Solution

Accepted Solutions
rubenmarin
Not applicable

Re: question about load order

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.

4 Replies
rubenmarin
Not applicable

Re: question about load order

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,

     F4

FROM

[.\brand_data2.xlsx]

(ooxml, embedded labels, table is data);

Data:

NoConcatenate LOAD * Resident Excel Order By Brand;

DROP table Excel;

larisa_filonova
Not applicable

Re: question about load order

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.

rubenmarin
Not applicable

Re: question about load order

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.

awhitfield
Not applicable

Re: question about load order

Hi Larisa,

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

Andy

Community Browser