topic Re: Suppress when value is null in expression in QlikView https://community.qlik.com/t5/QlikView/Suppress-when-value-is-null-in-expression/m-p/34907#M770298 <HTML><HEAD></HEAD><BODY><P>You can do this as expression?</P><P></P><P><STRONG>Sum({&lt;[SERIAL NUMBER] = {"=Len([SERIAL NUMBER])&gt;0"}&gt;} QUANTITY)</STRONG></P></BODY></HTML> Fri, 01 Jun 2018 03:18:39 GMT Anil_Babu_Samineni 2018-06-01T03:18:39Z Suppress when value is null in expression https://community.qlik.com/t5/QlikView/Suppress-when-value-is-null-in-expression/m-p/34904#M770295 <HTML><HEAD></HEAD><BODY><P>Hello There,</P><P></P><P>How to suppress null using <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">expression?</SPAN></P><P></P><P>sample data</P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid rgb(0, 0, 0); width: 258px; height: 67px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SERIAL NUMBER</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>QUANTITY</STRONG></TH></TR><TR><TD style="padding: 2px;">544258</TD><TD style="padding: 2px;">G600XYZ</TD><TD style="padding: 2px;">-12</TD></TR><TR><TD style="padding: 2px;">622120</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-1</TD></TR></TBODY></TABLE><P></P><P>Output</P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid #000000; width: 258px; height: 67px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SERIAL NUMBER</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>QUANTITY</STRONG></TH></TR><TR><TD style="padding: 2px;">544258</TD><TD style="padding: 2px;">G600XYZ</TD><TD style="padding: 2px;">-12</TD></TR></TBODY></TABLE><P></P><P></P><P>Best Regards,</P><P>Bing</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Suppress-when-value-is-null-in-expression/m-p/34904#M770295 bsbernabe 2020-11-25T16:16:04Z Re: Suppress when value is null in expression https://community.qlik.com/t5/QlikView/Suppress-when-value-is-null-in-expression/m-p/34905#M770296 <HTML><HEAD></HEAD><BODY><P>Which object is this? Straight table or pivot table?</P></BODY></HTML> Thu, 31 May 2018 11:29:40 GMT https://community.qlik.com/t5/QlikView/Suppress-when-value-is-null-in-expression/m-p/34905#M770296 sunny_talwar 2018-05-31T11:29:40Z Re: Suppress when value is null in expression https://community.qlik.com/t5/QlikView/Suppress-when-value-is-null-in-expression/m-p/34906#M770297 <HTML><HEAD></HEAD><BODY><P>try this <IMG alt="nullvalues.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/204027_nullvalues.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 31 May 2018 13:15:37 GMT https://community.qlik.com/t5/QlikView/Suppress-when-value-is-null-in-expression/m-p/34906#M770297 buzzy996 2018-05-31T13:15:37Z Re: Suppress when value is null in expression https://community.qlik.com/t5/QlikView/Suppress-when-value-is-null-in-expression/m-p/34907#M770298 <HTML><HEAD></HEAD><BODY><P>You can do this as expression?</P><P></P><P><STRONG>Sum({&lt;[SERIAL NUMBER] = {"=Len([SERIAL NUMBER])&gt;0"}&gt;} QUANTITY)</STRONG></P></BODY></HTML> Fri, 01 Jun 2018 03:18:39 GMT https://community.qlik.com/t5/QlikView/Suppress-when-value-is-null-in-expression/m-p/34907#M770298 Anil_Babu_Samineni 2018-06-01T03:18:39Z