List Box Sort

[hkg_qlik]

I have a LIST BOX holding the Impact Values: High, Medium and Low.

I want them to sort in the following order in the list box :

High

Medium

Low

Expression in the list box:

=Count( {$<Impact= {'High','Medium','Low'} >} Distinct [Incident Number] )

Regards,

H

[chematos]

try this in the properties:

=match([Impact Values],'High','Medium ','Low')

Order ascending

hope this helps

[#3]

Another way is to create flag in the script: High =1, Medium - 2, Low - 3. Then in the Properties, sort ascending by this flag.

Hope it helps.

[hkg_qlik]

=match([Impact Values],'High','Medium ','Low')

Order ascending

I tried it but its not working in this scenario.

H

[hkg_qlik]

Hi Max,

Are you suggesting to create an inline load for the flag in the backend script.

Thanks,

H

[chematos]

your field is Impact, not [Impact Values]

=match(Impact,'High','Medium ','Low')