topic Re: Sorting in QlikView

Sorting

brindlogcool — Thu, 18 Apr 2013 04:00:59 GMT

Hi,

I am trying to sort the text field (Full Name ) in the load Script as ascending order. but it is not working.

Anyone has faced the similar issue or is there anything i am missing.

I am able to sort the field in the list box using the Text option but not at the load script.

Re: Sorting

kaushiknsolanki — Thu, 18 Apr 2013 06:55:36 GMT

Hi,

As far as i know, order by works with resident load not with load statement.

So try like this.

Data:

Load * inline [

Field1

];

Data1:

Load Field1 as Field2 resident Data order by Field1 asc;

Regards,

Kaushik Solanki

Re: Sorting

Thu, 18 Apr 2013 07:27:59 GMT

Hi brindlogcool ,

You can use <TableName> Order By <ColumnName> in Load script itself and in the Properties Sort Tab, try sort by Load Order and select the option Original.

Thanks,

Selva

Re: Sorting

sushil353 — Thu, 18 Apr 2013 10:10:50 GMT

try to check your sorting setting in qlikview.. set it to load order...

HTH

Sushil

Re: Sorting

brindlogcool — Thu, 18 Apr 2013 14:50:06 GMT

Thanks for all you replies.

I did used the order by and set the load order in the list box still it is not working. I am facing the issue for the first time. For my previous project it is working fine.

It was a concatenated name first name and last name (ex Amy,Jackson) and even i replaced it ass Amy Jackson still it is not working. I am doing the sorting in the resident table.

Re: Sorting

brindlogcool — Fri, 19 Apr 2013 04:57:09 GMT

Text sorting is not working in the Load script. Any one had faced the similar issue?