topic Question about null value in QlikView https://community.qlik.com/t5/QlikView/Question-about-null-value/m-p/492331#M184095 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>It's me again.. </P><P>I recently have the expression:</P><P>=if(Len(Vipmail)=0,'No','Yes')</P><P>In database there are some vips have not input mail address,</P><P>I got the Listbox having 2 Rows finally, buy for the 'No' field, </P><P>it's always in grey color</P><P></P><P>Does anyone have any idea?</P><P></P><P>Many Thanks</P><P></P><P>Calvin Lin</P></BODY></HTML> Mon, 30 Sep 2013 07:08:39 GMT 2013-09-30T07:08:39Z Question about null value https://community.qlik.com/t5/QlikView/Question-about-null-value/m-p/492331#M184095 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>It's me again.. </P><P>I recently have the expression:</P><P>=if(Len(Vipmail)=0,'No','Yes')</P><P>In database there are some vips have not input mail address,</P><P>I got the Listbox having 2 Rows finally, buy for the 'No' field, </P><P>it's always in grey color</P><P></P><P>Does anyone have any idea?</P><P></P><P>Many Thanks</P><P></P><P>Calvin Lin</P></BODY></HTML> Mon, 30 Sep 2013 07:08:39 GMT https://community.qlik.com/t5/QlikView/Question-about-null-value/m-p/492331#M184095 2013-09-30T07:08:39Z