Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Custom sort list box

Hi,

I have a list box created with an expression =[Product ID] & ' - ' & [Product Description] that has values like

001 - abc

123 - bcs

234 - 276

I want to sort the list box by the product Description in ascending order. Kindly suggest!

Thanks!

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Custom sort list box

Try this

Rank(Only({1} [ProductDescription]))

With Descending sort

Capture.PNG

View solution in original post

13 Replies
Highlighted

Re: Custom sort list box

May be try a sort expression like this

Only({1} [Product Description])

and select ascending

Highlighted
Not applicable

Re: Custom sort list box

Did not work

Highlighted

Re: Custom sort list box

Would you be able to share a sample where this isn't working?

Highlighted
Not applicable

Re: Custom sort list box

I have attached a sample.

Highlighted
Esteemed Contributor III

Re: Custom sort list box

Can you do like

= ProductDescription & '-' & [Product ID]

Then Sort tab -> Check Text - A-Z.

Will that work?

Highlighted
Not applicable

Re: Custom sort list box

Does not work

Highlighted

Re: Custom sort list box

Try this

Rank(Only({1} [ProductDescription]))

With Descending sort

Capture.PNG

View solution in original post

Highlighted
Not applicable

Re: Custom sort list box

Thank you Sunny. This is correct!

Highlighted
Esteemed Contributor III

Re: Custom sort list box

Thanks Sunny, its been long go I have used something like Rank in sort. Thanks for refreshing memory. 🙂