topic Order in QlikView

Order

pgalvezt — Tue, 23 Aug 2011 22:25:30 GMT

Hi,

I have an Excel file. with format in text What I want is convert to Number.

And the Order the example. Or Order directly the example. How can I get this?:

Thanks.

fosuzuki — Wed, 24 Aug 2011 00:28:40 GMT

HI,

I'm not sure if this is the best solution, but you can use a Dual field.

In the script, create only one field like:

Example:

load dual(Code, Number) as Code;

Load * Inline [

Number,Code

1,14

3,26

4,36

2,CF

];

And then on the listbox or other object, use the Code field and sort it by a Numerical value.

Hope this helps you.

Regards,

Fernando

pgalvezt — Wed, 24 Aug 2011 16:03:01 GMT

Its works!!

Many Thanks!