Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
subin6600
Contributor III

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

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

3 Replies
MVP
MVP

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

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.

subin6600
Contributor III

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

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?

MVP
MVP

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

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

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

Community Browser