Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Frédéricdh
Creator II
Creator II

Sort a Dimension in Listbox

I use the function Match to sort a dimension in the Sort Expression:

 

My Function is like Match ( Facility, 'A', 'B', 'C'), but when I click the ANL B, the order change and I see the convenient number for 'A' and 'C' is Null.

 

What must I do, to keep the right number

Labels (1)
1 Solution

Accepted Solutions
Frédéricdh
Creator II
Creator II
Author

I find it, u have to write this Match(Only ({1} Facility), 'A', 'B', 'C')

 

and i works

View solution in original post

1 Reply
Frédéricdh
Creator II
Creator II
Author

I find it, u have to write this Match(Only ({1} Facility), 'A', 'B', 'C')

 

and i works