topic How to Sort Data in a Text Box? in QlikView

How to Sort Data in a Text Box?

Tue, 26 Jul 2011 13:27:57 GMT

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

How to Sort Data in a Text Box?

Tue, 26 Jul 2011 13:38:23 GMT

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

How to Sort Data in a Text Box?

swuehl — Tue, 26 Jul 2011 13:44:14 GMT

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

How to Sort Data in a Text Box?

Tue, 26 Jul 2011 13:49:15 GMT

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

Regards

Arun