topic Re: List Box Sort in QlikView

List Box Sort

hkg_qlik — Thu, 07 Jun 2012 16:01:12 GMT

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,

chematos — Thu, 07 Jun 2012 18:29:22 GMT

try this in the properties:

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

Order ascending

hope this helps

Thu, 07 Jun 2012 18:52:44 GMT

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 — Thu, 07 Jun 2012 19:05:38 GMT

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

Order ascending

I tried it but its not working in this scenario.

hkg_qlik — Thu, 07 Jun 2012 19:13:56 GMT

Hi Max,

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

Thanks,

chematos — Thu, 07 Jun 2012 19:18:01 GMT

your field is Impact, not [Impact Values]

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