topic Re: List Box Sorting in QlikView

List Box Sorting

krishna20 — Thu, 19 Feb 2015 07:09:26 GMT

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

Thu, 19 Feb 2015 07:28:44 GMT

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 — Thu, 19 Feb 2015 07:33:36 GMT

Hi,

You can try this in the expression sort option

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

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

Regards

Anand

Anonymous — Thu, 19 Feb 2015 07:46:22 GMT

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.