Null value at the bottom

[Smeenakshi23]

can we display null value at the bottom of the list box.. There is a filed called origin and it has null value, it always displays at the top of the list box. I need to display the null value at the bottom.qlikc

[jonathandienst]

True null values do not display in a list box. You may have an empty string or a NULLASVALUE setting for that field. If its not responding to an alpha sort, then its possibly the latter.

[Smeenakshi23]

Yeah ypu are correct I have an empty string at the top of the lust box. So we cannot move that to botoom of the list box?

[jonathandienst · Accepted solution]

Then you should be able to use a sort by expression. Something like

     =If(Len(Data)>0, Data, 'ZZZZZZ')

That's for an alpha text field. If the field is numeric, change the ZZZZ to a higher number than any of the real numbers.