Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Null Value Selection

Is it possible to make a Null value selectable?

From example in a Table Box with fields Product, SubProduct.

In the event that a sub product does not exist a '-' is displayed. Is it possible to make this '-' value selectable in the Table box?

Any suggestions are appreciated.

G

Labels (1)
1 Reply
Miguel_Angel_Baeyens

Hello,

That symbol is by default, you can change it in the chart properties, for example. If you want to perform a query on null values, try using

Len(Field) = 0
or
IsNull(Field)
in your conditions to get those values.

Regards.