topic Re: Null value at the bottom in QlikView

Null value at the bottom

Smeenakshi23 — Thu, 03 May 2018 11:10:03 GMT

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

Re: Null value at the bottom

jonathandienst — Thu, 03 May 2018 11:26:57 GMT

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.

Re: Null value at the bottom

Smeenakshi23 — Thu, 03 May 2018 11:49:18 GMT

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?

Re: Null value at the bottom

jonathandienst — Thu, 03 May 2018 12:35:08 GMT

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.