topic Null Value Selection in QlikView https://community.qlik.com/t5/QlikView/Null-Value-Selection/m-p/219134#M72180 <HTML><HEAD></HEAD><BODY><P>Is it possible to make a Null value selectable?</P><P>From example in a Table Box with fields Product, SubProduct.</P><P>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?</P><P>Any suggestions are appreciated.</P><P>G</P></BODY></HTML> Tue, 20 Apr 2010 13:33:48 GMT 2010-04-20T13:33:48Z Null Value Selection https://community.qlik.com/t5/QlikView/Null-Value-Selection/m-p/219134#M72180 <HTML><HEAD></HEAD><BODY><P>Is it possible to make a Null value selectable?</P><P>From example in a Table Box with fields Product, SubProduct.</P><P>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?</P><P>Any suggestions are appreciated.</P><P>G</P></BODY></HTML> Tue, 20 Apr 2010 13:33:48 GMT https://community.qlik.com/t5/QlikView/Null-Value-Selection/m-p/219134#M72180 2010-04-20T13:33:48Z Null Value Selection https://community.qlik.com/t5/QlikView/Null-Value-Selection/m-p/219135#M72181 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>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</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Len(Field) = 0</PRE></BLOCKQUOTE>or <BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">IsNull(Field)</PRE></BLOCKQUOTE>in your conditions to get those values. <BR /><BR /> <P>Regards.</P></BODY></HTML> Tue, 20 Apr 2010 15:05:41 GMT https://community.qlik.com/t5/QlikView/Null-Value-Selection/m-p/219135#M72181 Miguel_Angel_Baeyens 2010-04-20T15:05:41Z