topic Re: List Box Sort in QlikView

List Box Sort

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

In have the following expression in a list box

=if(Inv_Criticality = 'A', 'Critical',

if(Inv_Criticality = 'B', 'Semi Critical',

if(Inv_Criticality = 'C', 'Non Critical',

'Others')))

However, I am struggling to sort in the following order which is

I get the following below when used Match

=Match(Inv_Criticality,'A','B','C','O')

Thank you,

Kind regards

Nayan

Anil_Babu_Samineni — Sat, 11 Nov 2017 13:27:05 GMT

Try to add your expression as

=if(Inv_Criticality = 'A', dual('Critical', 1)

if(Inv_Criticality = 'B', dual('Semi Critical',2),

if(Inv_Criticality = 'C', dual('Non Critical',3),

Dual( 'Others',4))))

MarcoWedel — Sat, 11 Nov 2017 19:47:29 GMT

Hi,

maybe one solution might be to change your sorting expression to:

=Match(Inv_Criticality,'C','B','A')

and sort in descending order.

hope this helps

regards

Marco

Anonymous — Sun, 12 Nov 2017 11:08:45 GMT

Thank you Marco. It worked.

Kind regards

Nayan