Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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