List Box Sorting

[krishna20]

Hi Friends,

I'm having the below expression using in list box.The values i need to show in the list box as of order Policy, Renewal, Endorsement.

I have changed expression in different ways and also the sorting properties.But, it's not working.

=Pick(Match(TP_TXN_TYPE, 'POL', 'REN', 'END'), 'Policy', 'Renewal', 'Endorsement')

Can anyone please help me out.

Regards

Krishna

[#2]

Hi,

that's the expression you need to write

=Match(ColumnName, 'Policy', 'Renewal', 'Endorsement')

and of course only sort by expression in the properties

Jacob

[its_anandrjs]

Hi,

You can try this in the expression sort option

=Match(TP_TXN_TYPE,  'Policy', 'Renewal', 'Endorsement')

Or

=Pick(Match(TP_TXN_TYPE, 'POL', 'REN', 'END'), 1, 2, 3)

Regards

Anand

[Anonymous]

Hi,

do a inline load

LOAD * INLINE [

TP_TXN_TYPE,TP_TXN_TYPE1

Policy,  1

Renewal,2

Endorsement,3

]

and then use TP_TXN_TYPE1 in your sort expression.

you can also use applymap to introduce TP_TXN_TYPE1 column in your table .. if you dont want to have join.