topic Re: Null +value in QlikView https://community.qlik.com/t5/QlikView/Null-value/m-p/111210#M758665 <HTML><HEAD></HEAD><BODY><P>thank you both its working fine <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 10 Sep 2018 09:13:09 GMT soniasweety 2018-09-10T09:13:09Z Null +value https://community.qlik.com/t5/QlikView/Null-value/m-p/111207#M758662 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P><A _jive_internal="true" data-avatarid="14628" data-externalid="" data-online="false" data-presence="null" data-userid="255011" data-username="ipcducquy" href="https://community.qlik.com/people/ipcducquy" style="font-weight: bold; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #8b8b8b; background-color: #f2f2f2;" target="_blank">Quy Nguyen</A><SPAN style="color: #a9a9a9; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;"> </SPAN></P><P><A _jive_internal="true" data-avatarid="15025" data-externalid="" data-online="false" data-presence="null" data-userid="206168" data-username="youssefbelloum" href="https://community.qlik.com/people/youssefbelloum" style="font-weight: bold; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #8b8b8b; background-color: #f2f2f2;" target="_blank">youssef belloum</A></P><P></P><P>i have field called&nbsp; Go_to&nbsp;&nbsp; the values i can see is</P><P></P><P>blank</P><P>direct</P><P>indirect</P><P></P><P></P><P>so my requirment is&nbsp;&nbsp;&nbsp;&nbsp; all null.blank treat as direct only</P><P></P><P>how can i do this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Null-value/m-p/111207#M758662 soniasweety 2020-11-25T16:16:04Z Re: Null +value https://community.qlik.com/t5/QlikView/Null-value/m-p/111208#M758663 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try like this:</P><P></P><P>table:</P><P>load</P><P></P><P><STRONG>if(len(trim(GO_TO_MAR)=0,'Direct', GO_TO_MAR) as GO_TO_MAR</STRONG></P><P></P><P>from...</P></BODY></HTML> Mon, 10 Sep 2018 09:07:49 GMT https://community.qlik.com/t5/QlikView/Null-value/m-p/111208#M758663 YoussefBelloum 2018-09-10T09:07:49Z Re: Null +value https://community.qlik.com/t5/QlikView/Null-value/m-p/111209#M758664 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><STRONG>if(len(trim(GO_TO_MAR)</STRONG></SPAN><SPAN style="color: #ff0000;"><STRONG>)</STRONG></SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><STRONG>=0,'Direct', GO_TO_MAR) as GO_TO_MAR</STRONG></SPAN></P></BODY></HTML> Mon, 10 Sep 2018 09:11:49 GMT https://community.qlik.com/t5/QlikView/Null-value/m-p/111209#M758664 Frank_Hartmann 2018-09-10T09:11:49Z Re: Null +value https://community.qlik.com/t5/QlikView/Null-value/m-p/111210#M758665 <HTML><HEAD></HEAD><BODY><P>thank you both its working fine <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 10 Sep 2018 09:13:09 GMT https://community.qlik.com/t5/QlikView/Null-value/m-p/111210#M758665 soniasweety 2018-09-10T09:13:09Z