How to Sort Data in a Text Box?

[#1]

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

[#2]

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

[swuehl · Accepted solution]

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

[#4]

Thanks swuehl... That's exactly what I was looking for. I was not aware of the third parameter of concat function.

Regards

Arun