topic isnull() in QlikView https://community.qlik.com/t5/QlikView/isnull/m-p/53285#M784156 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi Experts,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Can any one please help me to convert below two sql logics into Qlik.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SELECT</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">ID,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #000000; font-style: inherit; font-family: inherit; font-weight: inherit;">ISNULL(CAST (<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">RESTI.</SPAN>KEY as NVARCHAR(1024))," ") KEY</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FROM</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mahitham 2020-11-25T16:16:04Z isnull() https://community.qlik.com/t5/QlikView/isnull/m-p/53285#M784156 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi Experts,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Can any one please help me to convert below two sql logics into Qlik.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SELECT</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">ID,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #000000; font-style: inherit; font-family: inherit; font-weight: inherit;">ISNULL(CAST (<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">RESTI.</SPAN>KEY as NVARCHAR(1024))," ") KEY</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FROM</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/isnull/m-p/53285#M784156 mahitham 2020-11-25T16:16:04Z Re: isnull() https://community.qlik.com/t5/QlikView/isnull/m-p/53286#M784157 <HTML><HEAD></HEAD><BODY><P>Hi Mahitha,</P><P></P><P>Try like this:</P><P></P><P>Load</P><P>ID,</P><P>if(isnull(PKEY)=-1,' ',PKEY) as PKEY,</P><P><SPAN style="font-size: 13.3333px;">if(isnull(<SPAN style="color: #ff0000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">DESCRIPTION</SPAN>)=-1,' ',<SPAN style="color: #ff0000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">DESCRIPTION</SPAN>) as <SPAN style="color: #ff0000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">DESCRIPTION</SPAN></SPAN></P><P><SPAN style="color: #ff0000; font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">from</SPAN></P><P><SPAN style="color: #ff0000; font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">&lt;&gt;<BR /></SPAN></P></BODY></HTML> Tue, 06 Mar 2018 06:28:06 GMT https://community.qlik.com/t5/QlikView/isnull/m-p/53286#M784157 jyothish8807 2018-03-06T06:28:06Z