Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
matspersson
Contributor
Contributor

Order of result from load

Loading from a qdf or resident table, is there any guaranties for in which order the rows are returned. E.g. the order they where inserted in the first place into the qdf or resident table.

Cheers

Mats 

3 Replies
matspersson
Contributor
Contributor
Author

Sorry, meant qvd file.

Vegar
MVP
MVP

It is a good question. I have not  seen anything  in the qlik documentation about load order from QVC, as long its undocumented there is no guarantee in behaviour. However you could assume the data to be loaded as entered into the qvw. 

If your order of data is important then you should order it explicit.

OrderedTable:

NoConcatenate

Load 

    *

Resident

    UnorderedTable

Order by

   YourOrderField 

;

Drop UnorderedTable; 

 

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
marcus_sommer
MVP & Luminary
MVP & Luminary

AFAIK the order depends of the point of view - from the data-table or from the symbol-table. The data-table is always loaded with the order from the source - unless you apply an order by statement. From the point of view of the symbol-table respectively the (distinct) fieldvalues it's different because it depends on whether the field exists already.

If the field didn't exists the load-order is identically with the load-order of the data-table but if the field exists only new fieldvalues are added and the pointer increased to one bit and is stored in the data-table - otherwise it's just a lookup to fetch the right pointer value.

You may check this with some of your data and/or a few dummy-data by applying recno/rowno to your origin and deduced loadings and maybe even to your source-data (which may stored in a different order as they are displayed).

- Marcus