Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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?
The syntax should be quite similar to QlikViews syntax, using SQL order by keyword