topic Script Entry in QlikView https://community.qlik.com/t5/QlikView/Script-Entry/m-p/175133#M43704 <HTML><HEAD></HEAD><BODY><P>Brilliant worked like a charm however now it has created a blank field at the top of the data when put into a list box. Is there a way to get rid of this?</P><P></P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/37373.Script.jpg"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/37373.Script.jpg" /></A></P></BODY></HTML> Mon, 08 Nov 2010 09:46:28 GMT 2010-11-08T09:46:28Z Script Entry https://community.qlik.com/t5/QlikView/Script-Entry/m-p/175131#M43702 <HTML><HEAD></HEAD><BODY><P>Hey Guys</P><P></P><P>In my script i need to get rid of a whole bunch of '0's in a specific field namely StockCode. I only need to keep the last 5 characters. In the Script the field is loaded and joined to its description like this:</P><P></P><P>(%StockCode&amp;'-'&amp;SalesDescr) as ProductMaster.</P><P></P><P>Has anyone got any ideas on how to Delete the unwanted 0s?</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2758_sourceID:2758" /></P></BODY></HTML> Mon, 08 Nov 2010 09:29:08 GMT https://community.qlik.com/t5/QlikView/Script-Entry/m-p/175131#M43702 2010-11-08T09:29:08Z Script Entry https://community.qlik.com/t5/QlikView/Script-Entry/m-p/175132#M43703 <HTML><HEAD></HEAD><BODY><P>Hi Blaze,</P><P>what about this:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />( Right( %StockCode,5) &amp;'-'&amp;SalesDescr) as ProductMaster.<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 08 Nov 2010 09:37:51 GMT https://community.qlik.com/t5/QlikView/Script-Entry/m-p/175132#M43703 2010-11-08T09:37:51Z Script Entry https://community.qlik.com/t5/QlikView/Script-Entry/m-p/175133#M43704 <HTML><HEAD></HEAD><BODY><P>Brilliant worked like a charm however now it has created a blank field at the top of the data when put into a list box. Is there a way to get rid of this?</P><P></P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/37373.Script.jpg"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/37373.Script.jpg" /></A></P></BODY></HTML> Mon, 08 Nov 2010 09:46:28 GMT https://community.qlik.com/t5/QlikView/Script-Entry/m-p/175133#M43704 2010-11-08T09:46:28Z Script Entry https://community.qlik.com/t5/QlikView/Script-Entry/m-p/175134#M43705 <HTML><HEAD></HEAD><BODY><P>Sorry it is not blank it is in fact a '-'</P></BODY></HTML> Mon, 08 Nov 2010 09:50:38 GMT https://community.qlik.com/t5/QlikView/Script-Entry/m-p/175134#M43705 2010-11-08T09:50:38Z Script Entry https://community.qlik.com/t5/QlikView/Script-Entry/m-p/175135#M43706 <HTML><HEAD></HEAD><BODY><P>Hi Blaze,</P><P>this depends on your data. I suppose that there is a nullvalue (or more, test it with "Show frequency") in one of the two input-fields.</P><P>RR</P></BODY></HTML> Mon, 08 Nov 2010 10:10:12 GMT https://community.qlik.com/t5/QlikView/Script-Entry/m-p/175135#M43706 2010-11-08T10:10:12Z