Discussion Board for collaboration related to Qlik Education.
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?
Go to Solution.
OK, as it is the same field, the loading sort order for Brand is set in the first load, you can try with:
LOAD Brand as Brand_Orig,
(ooxml, embedded labels, table is data)
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.
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:
(ooxml, embedded labels, table is data);
NoConcatenate LOAD * Resident Excel Order By Brand;
DROP table Excel;
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.
you list box is set to load order, set it to Text A-Z