topic Sorting Nvarchar datatype in QlikView

Sorting Nvarchar datatype

Mon, 01 Jul 2013 08:58:56 GMT

Hi All,

Please find the attched excel .I want to sort based on the hard disk size. Could you please help in getting the solution?

Thanks,

Rahul

Re: Sorting Nvarchar datatype

Mon, 01 Jul 2013 12:49:18 GMT

Try this:

Directory;

LOAD @1 as Capacity,

Num#(Replace(@1, 'GB', ''), '#.#', '.', ',') as NCapacity

FROM

HD.xls

(biff, no labels, table is [Sheet1$]);

and order by field NCapacity.

Re: Sorting Nvarchar datatype

Hugo_Sheng — Tue, 02 Jul 2013 21:09:02 GMT

Are you looking to perform the sort in Expressor or QlikView?

There's a dedicated Sort operator in Expressor that allows you to specify the sort key(s) and then allows you to subsequently process the data accordingly.

Re: Sorting Nvarchar datatype

Wed, 03 Jul 2013 10:53:11 GMT

Opps! I think I didn't read the discussion group name and I thought I was in a QlikView discussion.

As Hugo says, you can use the Sort operator. I have created a Dataflow to test the solution:

Re: Sorting Nvarchar datatype

Wed, 03 Jul 2013 11:10:22 GMT

Qlikview

Re: Sorting Nvarchar datatype

Wed, 03 Jul 2013 11:35:39 GMT

Atatched QVW for reference.

test:

LOAD left(@1,len(@1)-1) as col1,@1 as col2 from c:\HD.XLS

(

biff, no labels, table is [Sheet1$])

(

Noconcatenate

test2:

load * resident test order by col1:

drop table test;

Re: Sorting Nvarchar datatype

Hugo_Sheng — Wed, 03 Jul 2013 14:41:13 GMT

Moving this to the proper discussion area