Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

balrajahlawat
Esteemed Contributor

Order by at script not working

Hello Qlikers,

Can some one help me to find out why Order By is not working with following syntax:

Load distinct

Date

resident Table

order by Date desc;



Regards,

Balraj

1 Solution

Accepted Solutions
sureshqv
Esteemed Contributor III

Re: Order by at script not working

2 Replies
sureshqv
Esteemed Contributor III

Re: Order by at script not working

Hi

ORDER BY in a LOAD statement can be used with RESIDENT tables.

If your source itselfs supports an order by (most common example: a SELECT ... FROM ... ORDER BY....Smiley Wink you can use this as well (note that the sorting is performed by the source DBMS, not QV).

Also note, that QV's ORDER BY is sorting the input table, not the ouput table (so won't result in a sorted table e.g. when using a LOAD DISTINCT).

sureshqv
Esteemed Contributor III

Re: Order by at script not working