This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I 'm having a problem. I want to sort numeric data (Smallest to Largest).
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.
One way could be like attched sample.
View solution in original post
You use the Rank function in Order. You see Guide.
Sorting the column is possible only with resident load not directly on files.
So load the file and use order by in resident load.
Load * from test .xlx;
Load * from resident Tab1 order by Column_name asc/desc; ( silmilar to sql order by)
Could you please give me example or QVW file?
But I want to sort by row and concatenate to new value.
Try to create a sample app with inline data and share here explaining expected output.
This QVW File for explain my expect output.
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
Because 312 sort by ascending order = 123
488 sort by ascending order = 488
991 sort by ascending order = 199