topic Dual function and sorting in QlikView

Dual function and sorting

brindlogcool — Thu, 22 Aug 2013 03:19:39 GMT

I had used the dual function in the list box and it works perfectly. But the sorting is not working. None of the options are not working in sorting. Any one has faced this issue earlier.

Re: Dual function and sorting

tresB — Thu, 22 Aug 2013 04:35:12 GMT

Can you share your sample app?

Re: Dual function and sorting

Wed, 28 Aug 2013 17:31:35 GMT

Hi,

You can do sorting by using rank() function for your text field. eg. if you are using dual(Name, ID) then in the sorting expression you may want to put rank(Name) in descending order. This will sort all your selected 'Name' field items in alphabetical order.

Additionally, if you need to sort even the non-selected 'Name' entries too. I will advice you to clear that field itself in the set expression and use '1' identifier before that. eg. rank(only{1<Name=>} Name).Now, it will consider full set of all your 'Name' records.

Hope this will help.

Regards,

Lokesh

Re: Dual function and sorting

Anonymous — Wed, 28 Aug 2013 18:27:40 GMT

Alwyas works for me... Make sure you order by numeric value.

Regards,

Michael