topic Re: Problem with null values in QlikView https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706129#M1064207 <HTML><HEAD></HEAD><BODY><P>Welcome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 16 Sep 2014 08:54:21 GMT ashfaq_haseeb 2014-09-16T08:54:21Z Problem with null values https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706123#M1064201 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i have some problem to craete null values replace with any text unknown' can you please suggest me</P></BODY></HTML> Tue, 16 Sep 2014 08:31:39 GMT https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706123#M1064201 2014-09-16T08:31:39Z Re: Problem with null values https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706124#M1064202 <HTML><HEAD></HEAD><BODY><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(<STRONG>IsNull</STRONG>(Field), 'Unknown', Field) as Field</P></BODY></HTML> Tue, 16 Sep 2014 08:32:56 GMT https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706124#M1064202 tresB 2014-09-16T08:32:56Z Re: Problem with null values https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706125#M1064203 <HTML><HEAD></HEAD><BODY><H4 class="syntax">Hi Sanjeev,</H4><P></P><P>Check this</P><H4 class="syntax"></H4><H4 class="syntax">SET NULLDISPLAY=&lt;sym&gt;;</H4><P></P><P><BR />Ex:</P><H4 class="syntax" style="font-size: 13.3333339691162px;">SET NULLDISPLAY='Unknown';</H4><P></P><P></P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 16 Sep 2014 08:36:12 GMT https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706125#M1064203 jagan 2014-09-16T08:36:12Z Re: Problem with null values https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706126#M1064204 <HTML><HEAD></HEAD><BODY><P>use below in your script...</P><P></P><P>IF(IsNull(YourFieldName) or LEN(TRIM(Replace(YourFieldName,'-','')))=0, 'Unknown',YourFieldName) as YourFieldName</P></BODY></HTML> Tue, 16 Sep 2014 08:36:46 GMT https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706126#M1064204 MK_QSL 2014-09-16T08:36:46Z Re: Problem with null values https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706127#M1064205 <HTML><HEAD></HEAD><BODY><P>Like this.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 16 Sep 2014 08:44:30 GMT https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706127#M1064205 ashfaq_haseeb 2014-09-16T08:44:30Z Re: Problem with null values https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706128#M1064206 <HTML><HEAD></HEAD><BODY><P>thanks Ashfaq</P></BODY></HTML> Tue, 16 Sep 2014 08:49:21 GMT https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706128#M1064206 2014-09-16T08:49:21Z Re: Problem with null values https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706129#M1064207 <HTML><HEAD></HEAD><BODY><P>Welcome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 16 Sep 2014 08:54:21 GMT https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706129#M1064207 ashfaq_haseeb 2014-09-16T08:54:21Z Re: Problem with null values https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706130#M1064208 <HTML><HEAD></HEAD><BODY><P>Sanjeev, </P><P>Happy to know that you got your answer...</P><P>Just for my curiosity, what was wrong with tresesco, Jagan or my answer?</P></BODY></HTML> Tue, 16 Sep 2014 08:54:46 GMT https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706130#M1064208 MK_QSL 2014-09-16T08:54:46Z Re: Problem with null values https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706131#M1064209 <HTML><HEAD></HEAD><BODY><P>I understood he gave with example</P></BODY></HTML> Tue, 16 Sep 2014 09:04:53 GMT https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706131#M1064209 2014-09-16T09:04:53Z Re: Problem with null values https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706132#M1064210 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 16 Sep 2014 09:05:34 GMT https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706132#M1064210 MK_QSL 2014-09-16T09:05:34Z Re: Problem with null values https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706133#M1064211 <HTML><HEAD></HEAD><BODY><P>Thanks for you replay guys</P></BODY></HTML> Tue, 16 Sep 2014 09:09:07 GMT https://community.qlik.com/t5/QlikView/Problem-with-null-values/m-p/706133#M1064211 2014-09-16T09:09:07Z