topic Re: Sorting in list box not working in QlikView

Sorting in list box not working

Thu, 12 Nov 2015 18:31:18 GMT

Hi Gurus,

I have list box with name of users, I want to sort by first name. Looks so trivial but nothing seems to be working.

Attached is the screenshot.

Thanks

Re: Sorting in list box not working

sunny_talwar — Thu, 12 Nov 2015 19:11:37 GMT

Try removing the check from State and text and see if that helps.

Re: Sorting in list box not working

Thu, 12 Nov 2015 19:14:20 GMT

Tried. Does not work

Re: Sorting in list box not working

Thu, 12 Nov 2015 19:17:57 GMT

I create sample list box with full_name and do sorting and it works. Wondering if it is because of the expression I have it does not work

=if(len(dual(full_name,aggr(only({<user_id =,full_name=>}user_id),full_name)))>=20,
mid(dual(full_name,aggr(only({<user_id =,full_name=>}user_id),full_name)),1,20),
dual(full_name,aggr(only({<user_id =,full_name=>}user_id),full_name)))

Re: Sorting in list box not working

sunny_talwar — Thu, 12 Nov 2015 19:45:19 GMT

Would you be able to share a sample?