topic Re: Alphabetical load order in QlikView

Alphabetical load order

Anonymous — Fri, 22 Feb 2013 15:39:52 GMT

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?

Re: Alphabetical load order

marcus_sommer — Fri, 22 Feb 2013 15:54:55 GMT

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

- Marcus

Re: Alphabetical load order

whiteline — Fri, 22 Feb 2013 16:01:06 GMT

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;

Re: Alphabetical load order

Anonymous — Fri, 22 Feb 2013 16:09:41 GMT

Nope - didnt work (see file)

Re: Alphabetical load order

whiteline — Fri, 22 Feb 2013 16:43:14 GMT

Indeed, works perfect for Company Name.

I think you could choose the field for sorting

Order by [Company name];

Re: Alphabetical load order

Anonymous — Fri, 22 Feb 2013 16:45:24 GMT

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

Re: Alphabetical load order

marcus_sommer — Fri, 22 Feb 2013 16:48:39 GMT

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

Re: Alphabetical load order

whiteline — Fri, 22 Feb 2013 16:52:56 GMT

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.

Re: Alphabetical load order

whiteline — Fri, 22 Feb 2013 16:55:06 GMT

As I understand, he want sorting within cocnat function.

Re: Alphabetical load order

Anonymous — Mon, 25 Feb 2013 16:20:20 GMT

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

Re: Alphabetical load order

Anonymous — Mon, 25 Feb 2013 16:44:06 GMT

This is what i have so far - still uploading alphabetically

any suggestions?

Re: Alphabetical load order

whiteline — Mon, 25 Feb 2013 19:23:42 GMT

Doesn't it what you want ?

subfield(concat([Company name],',', [Row]),',',1) = Janes Crisps

subfield(concat([Company name],',', [Row]),',',2) = Bobs burgers

subfield(concat([Company name],',', [Row]),',',3) = Dave’s tyres