Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I sthere a way to sort data in a textbox?
I was thinking of displaying comments from an excel file to be displayed using a text object. But the text object automatically sorts the data by text sort (A-> Z). I wanted to sort the data by load order. Is this possible in a text object?
Regards
Arun
You use concat function for displaying the comments?
concat function takes a third parameter for sort order, so if you got a field with unique ascending number (e.g. using row number), you could try in text boxes expression:
=concat(CommentField, ',', AscendingNumberField)
Maybe this link is also helpful
http://community.qlik.com/message/132579#132579
Regards,
Stefan
hi,
you can use the function concat(). Default, this function sort value by text sort.
example : =concat(distinct Sellers,' - ')
All the distinct sellers wil be display with a "-" between each value.
Regards,
Valentin
You use concat function for displaying the comments?
concat function takes a third parameter for sort order, so if you got a field with unique ascending number (e.g. using row number), you could try in text boxes expression:
=concat(CommentField, ',', AscendingNumberField)
Maybe this link is also helpful
http://community.qlik.com/message/132579#132579
Regards,
Stefan
Thanks swuehl... That's exactly what I was looking for. I was not aware of the third parameter of concat function.
Regards
Arun