topic Re: Load order in QlikView

Load order

dusasuman — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I am loading one table in Ascending order based on two fields UnitNumber and Activity date to perform few calculations. But the same Unit number will have 2 or more Activity dates for these records i need load by its original load order.

Is it possible to load a table by load order at this instance.?

Please help me with your suggestions..

Re: Load order

jonathandienst — Wed, 27 Jul 2016 06:24:36 GMT

You might want to add a sequence number field to the table during the original load, then use this sequence number to sort by the original load order:

LOAD ....

...

RowNo() as SequenceID,

...

Re: Load order

dusasuman — Wed, 27 Jul 2016 06:30:23 GMT

Hi Jonathan..

Thanks for your suggestion.. But i am loading Unit Number and Activity date in Desc order,, when multiple records occurs at same Unit Number and same Activity Date the i Need to load by ascending order of Sequence ID.. Is it possible to load by combination of Asc and Desc order?

Re: Load order

jonathandienst — Wed, 27 Jul 2016 06:39:20 GMT

ORDER BY UnitNumber asc, ActivityDate asc, SequenceID desc

(Asc is the default direction , it can be omitted - and usually is)

ORDER BY UnitNumber, ActivityDate, SequenceID desc

Re: Load order

dusasuman — Wed, 27 Jul 2016 06:50:54 GMT

At that instance it is not considering order of SequenceID.. It is Just ignoring order of SequenceID..

Not sure what happening with load order..

Thnaks...