topic isnull in Qlikview in QlikView https://community.qlik.com/t5/QlikView/isnull-in-Qlikview/m-p/901056#M469221 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I am going to set analysis for the straight table to get the total of revenue that got cancelled.</P><P></P><P>What I am used is sum(if ( order_status='Cancelled' and isnull(InvoiceItemID) Revenue_USD))</P><P>The expression itself does not have any syntax error, but the result is way off.</P><P>I am wondering if there is any way to get the null values for InvoiceItemID field so that the revenue associated with those null InvoiceItems will be summed up.</P><P></P><P>Can anyone please help me out?</P><P></P><P>Thank you so much in advance!</P><P></P><P>Best Regards,</P><P>Gloria</P></BODY></HTML> Fri, 17 Jul 2015 22:49:26 GMT 2015-07-17T22:49:26Z isnull in Qlikview https://community.qlik.com/t5/QlikView/isnull-in-Qlikview/m-p/901056#M469221 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I am going to set analysis for the straight table to get the total of revenue that got cancelled.</P><P></P><P>What I am used is sum(if ( order_status='Cancelled' and isnull(InvoiceItemID) Revenue_USD))</P><P>The expression itself does not have any syntax error, but the result is way off.</P><P>I am wondering if there is any way to get the null values for InvoiceItemID field so that the revenue associated with those null InvoiceItems will be summed up.</P><P></P><P>Can anyone please help me out?</P><P></P><P>Thank you so much in advance!</P><P></P><P>Best Regards,</P><P>Gloria</P></BODY></HTML> Fri, 17 Jul 2015 22:49:26 GMT https://community.qlik.com/t5/QlikView/isnull-in-Qlikview/m-p/901056#M469221 2015-07-17T22:49:26Z Re: isnull in Qlikview https://community.qlik.com/t5/QlikView/isnull-in-Qlikview/m-p/901057#M469222 <HTML><HEAD></HEAD><BODY><P>The field might show not NULL, but empty or blank values. </P><P></P><P>A safer way to handle NULL as well as empty or blank values is </P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(if ( order_status='Cancelled' and l<STRONG>en(trim(InvoiceItemID))=0</STRONG>, Revenue_USD))</SPAN></P></BODY></HTML> Fri, 17 Jul 2015 22:55:41 GMT https://community.qlik.com/t5/QlikView/isnull-in-Qlikview/m-p/901057#M469222 swuehl 2015-07-17T22:55:41Z