topic Re: How can we sort the data while loading it into Qlikview? in QlikView

How can we sort the data while loading it into Qlikview?

subin6600 — Thu, 27 Sep 2012 09:22:08 GMT

Hi Qlikviewrs!!

I need to sort the data while it is being read from the data sources. How is it possible??

I don't have any connectors available nor can install them.

Any help would be appreciated.

Thanks & Regards,

Subin Thomas

Re: How can we sort the data while loading it into Qlikview?

swuehl — Thu, 27 Sep 2012 09:41:46 GMT

As far as I know, you can only sort a resident table by the means of QV itself, using order by clause.

That means, you need to load your data first in, then do a resident load with the sort (take care of unwanted concatenation using noconcatenate, and probably dropping the first table after the second load).

If you are connecting to a DB using SQL, you can of course use SQL to retrieve your records already sorted.

Re: How can we sort the data while loading it into Qlikview?

subin6600 — Thu, 27 Sep 2012 11:39:10 GMT

Hi Swuehl, Thanks for the reply

Yes, the data base is SQL.

I want the Month & Year (two fields) be sorted not a date.

What are the SQL functions to sort it?

temp:

Load

Year,

Month,

Primarykey

;

SQL Select

Year,

Month,

Primarykey

From temp xyz;

What would be the syntax for sorting?

Re: How can we sort the data while loading it into Qlikview?

swuehl — Thu, 27 Sep 2012 11:52:43 GMT

The syntax should be quite similar to QlikViews syntax, using SQL order by keyword

http://www.w3schools.com/sql/sql_orderby.asp