Alphabetical load order

[Anonymous]

I'm loading data into a table, I've concatenated it to show you simply. The data is loaded in this order:

Janes Crisps

Bobs burgers

Dave’s tyres

However, when i load it in qlikview it comes through like this:

Bobs burgers

Dave’s tyres

Janes Crisps

It runs them through alphabetically. I've changed the sort type to 'load order' but that doesnt work. Can anyone tell me how i load information so that it isnt alphabetical and that it loads it as it's stored in the table?

[marcus_sommer]

QlikView sorts in GUI fields automatically, but you can set/change the sort order in all objects separate - see properties/sort.

- Marcus

[whiteline]

Data:

LOAD [Client Manager],

     [Company name],

     [Client name],

     [Phone number]

FROM

..\users.xlsx

(ooxml, embedded labels, table is Sheet1);

SortedData:

NoConcatenate

LOAD

*

Resident Data

Order by [Company name];

Drop table Data;

[Anonymous]

Nope - didnt work (see file)

[whiteline]

Indeed, works perfect for Company Name.

I think you could choose the field for sorting

Order by [Company name];

[Anonymous]

If i order by company name it puts it in alphabetical order. I want it in load order.

[marcus_sommer]

You can use rowno() and sort so in load order.

[whiteline]

Ah...

LOAD

      RowNo() as Row,

      [Client Manager],

      [Company name],   

      [Client name],

      [Phone number]

FROM

..\users.xlsx

(ooxml, embedded labels, table is Sheet1);

And then use Row as sorting order.

[whiteline]

As I understand, he want sorting within cocnat function.

[Anonymous]

Yes, i'd like it sorted within the concat function. Sorting it by rowno seemed like a good idea but didnt work..