Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
maxloveiii
Contributor III
Contributor III

How to sort numeric by function in script?

     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.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

One way could be like attched sample.

View solution in original post

9 Replies
antoniotiman
Master III
Master III

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

Regards

sivarajs
Specialist II
Specialist II

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
Contributor III
Contributor III
Author

Could you please give me example or QVW file?

maxloveiii
Contributor III
Contributor III
Author

Thanks

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

tresesco
MVP
MVP

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

maxloveiii
Contributor III
Contributor III
Author

This QVW File for explain my expect output.

tresesco
MVP
MVP

One way could be like attched sample.

Not applicable

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
Contributor III
Contributor III
Author

Because  312 sort by ascending order = 123

               488 sort by ascending order = 488

               991 sort by ascending order = 199