topic Re: How to sort numeric by function in script? in QlikView

How to sort numeric by function in script?

maxloveiii — Thu, 03 Apr 2014 09:13:46 GMT

I 'm having a problem. I want to sort numeric data (Smallest to Largest).

Example.

row A, B, C

1 4, 8, 2

2 2, 5, 1

?(A,B,C) Return 248 (row 1)

?(A,B,C) Return 125 (row 2)

What a function to solve this?

Thanks for any help.

antoniotiman — Thu, 03 Apr 2014 09:25:43 GMT

You use the Rank function in Order. You see Guide.

Regards

sivarajs — Thu, 03 Apr 2014 09:39:42 GMT

Sorting the column is possible only with resident load not directly on files.

So load the file and use order by in resident load.

Tab1:

Load * from test .xlx;

Tab2:

Load * from resident Tab1 order by Column_name asc/desc; ( silmilar to sql order by)

maxloveiii — Thu, 03 Apr 2014 10:01:36 GMT

Could you please give me example or QVW file?

maxloveiii — Thu, 03 Apr 2014 10:06:48 GMT

Thanks sivarajs

But I want to sort by row and concatenate to new value.

tresB — Thu, 03 Apr 2014 10:18:08 GMT

Try to create a sample app with inline data and share here explaining expected output.

maxloveiii — Thu, 03 Apr 2014 10:38:41 GMT

This QVW File for explain my expect output.

tresB — Thu, 03 Apr 2014 10:46:55 GMT

One way could be like attched sample.

Thu, 03 Apr 2014 11:00:58 GMT

What logic are you using to transform the data.

If 312 is to be transformed as123 then how 488 remains unchanged and 991 changed to 199

maxloveiii — Fri, 04 Apr 2014 02:57:17 GMT

Because 312 sort by ascending order = 123

488 sort by ascending order = 488

991 sort by ascending order = 199