topic Re: How to write the expression in QlikView https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993908#M966308 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>if(isnull(NetStock) or len(trim(NetStock))=0,'Null',YourExpression)</P><P></P><P>Regards</P></BODY></HTML> Mon, 05 Oct 2015 07:55:23 GMT PrashantSangle 2015-10-05T07:55:23Z How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993906#M966306 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">How to write the following in qlikview expression:</SPAN></P><P></P><P>if NettStock is NULL then Null</P><P>Else </P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">if(NettStock&lt; sum([OutStanding Qty]),NettStock-sum([OutStanding Qty]),NettStock)</SPAN></P></BODY></HTML> Mon, 05 Oct 2015 07:51:51 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993906#M966306 suvechha_b 2015-10-05T07:51:51Z Re: How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993907#M966307 <HTML><HEAD></HEAD><BODY><P>Hi Suveccha</P><P></P><P>You can ALT function for this..</P></BODY></HTML> Mon, 05 Oct 2015 07:54:18 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993907#M966307 SreeniJD 2015-10-05T07:54:18Z Re: How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993908#M966308 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>if(isnull(NetStock) or len(trim(NetStock))=0,'Null',YourExpression)</P><P></P><P>Regards</P></BODY></HTML> Mon, 05 Oct 2015 07:55:23 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993908#M966308 PrashantSangle 2015-10-05T07:55:23Z Re: How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993909#M966309 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/100908_Capture.PNG" style="width: 620px; height: 250px;" /></P></BODY></HTML> Mon, 05 Oct 2015 07:56:38 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993909#M966309 PrashantSangle 2015-10-05T07:56:38Z Re: How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993910#M966310 <HTML><HEAD></HEAD><BODY><P>try like this:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">if (len(trim(NettStock))=0 ,null(),</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">&nbsp;&nbsp;&nbsp; <SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">if(NettStock&lt; sum([OutStanding Qty]),NettStock-sum([OutStanding Qty]),NettStock))</SPAN></P></BODY></HTML> Mon, 05 Oct 2015 08:03:23 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993910#M966310 avinashelite 2015-10-05T08:03:23Z Re: How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993911#M966311 <HTML><HEAD></HEAD><BODY><P>=if(len( trim(NettStock))=0,'Null',if(NettStock&lt; sum([OutStanding Qty]),NettStock-sum([OutStanding Qty]),NettStock))</P></BODY></HTML> Mon, 05 Oct 2015 08:06:41 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993911#M966311 sasiparupudi1 2015-10-05T08:06:41Z Re: How to write the expression https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993912#M966312 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P></P><P>=if(Len(Trim(NettStock)) =&nbsp; 0, 'Null',</P><P>&nbsp;&nbsp;&nbsp;&nbsp; if(NettStock&lt; sum([OutStanding Qty]),NettStock-sum([OutStanding Qty]),NettStock))</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 05 Oct 2015 08:07:40 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression/m-p/993912#M966312 jagan 2015-10-05T08:07:40Z