Null/missing values in a table

[Nikhil_562]

Hi everyone,

I am new to Qlik Sense. I am facing a problem with null values in a table. When I sort in Ascending order I am getting null values at the top followed by other values in ascending order.

I want to show my data in a way that null values should be at the end while other values to be sort according to Ascending/descending sort order.

Do we any method/function in Qlik Sense to get this done.

Thanks 

[micheledenardi]

Null values are always a signal of a bad data model for several reasons like:

- you cannot select null values from listboxes.

- on all objects has some missing functionalities to manage nulls values.

I warmly recommend to replace nulls with a default string (i usually set them as "Not Set") in the load script.

This would really help.