Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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?
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.