topic Re: What expression to use to put one specific value on bottom of a list box in QlikView

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

rudywelvaert — Wed, 17 Jan 2018 19:15:58 GMT

Hi,

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

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

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.

sunny_talwar — Wed, 17 Jan 2018 19:21:08 GMT

Try this

rudywelvaert — Wed, 17 Jan 2018 19:33:09 GMT

Thanks Sunny,

This works

R.W.