topic Custom sort list box in QlikView

Custom sort list box

Tue, 12 Nov 2013 00:04:50 GMT

Hi,

I'm trying to sort a list box by expression in order to show the data in a certain way.For example if I want a list of names to appear in this order: Kevin, Alex, Zuri, Daniel, Monica, Betty.

Re: Custom sort list box

Anonymous — Tue, 12 Nov 2013 03:02:28 GMT

In the sort by select expression. An example is the following where

* fieldname is field you are sorting

=Pick(Match([FieldName],'Kevin','Alex','Zuri', 'Daniel', 'Monica', 'Betty')

,1,2,3,4,5,6

)

Re: Custom sort list box

jagan — Tue, 12 Nov 2013 04:19:42 GMT

Hi,

Add this script in your Qlikview file

NamesOrder:

LOAD * INLINE [

Name, NameSortOrder

Kevin, 1

Alex, 2

Zuri, 3

Daniel,4

Monica,5

Betty, 6 ];

Now in the sort tab of the Properties select expression and give

=NameSortOrder

Hope this helps you.

Regards,

Jagan.

Re: Custom sort list box

Tue, 12 Nov 2013 17:49:59 GMT

Thanks for your help

Re: Custom sort list box

Clever_Anjos — Wed, 13 Nov 2013 01:23:12 GMT

another way

=Index('Kevin,Alex,Zuri,Daniel,Monica,Betty',[FieldName])