Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rudywelvaert
Creator
Creator

What expression to use to put one specific value on bottom of a list box

Hi,

In a list box I have following values based on Field CODE in a table CODES:

Code_N.png

I want the list box be sorted in such a way that the value Nihil is the last value:


Code_C.png

In the Sort tab of the Properties of the list box I use the following Expression:


=If(CODE='Nihil', '1', '0') & CODE


but nothing changes.


Thanks

R.W.

1 Solution

Accepted Solutions
sunny_talwar

2 Replies
sunny_talwar

Try this

Capture.PNG

rudywelvaert
Creator
Creator
Author

Thanks Sunny,

This works

Code_S.png

R.W.