Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to sort the data by the expression in ListBox

test:

load * Inline [
customer
00010 BBBBB
00020 CCCCC
00030 AAAAA
00040 DDDDD
]

I want to get:

00030  AAAAA

00010  BBBBB

00020  CCCCC

00040  DDDDD

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     ListBox Properties-->Sort tab-->Sort by expression as =Rank(SubField(customer,' ',2))

Celambarasan

Not applicable
Author

Thanks, is OK