topic Re: How to make BC9000 display as BC9000_ ? in QlikView https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666489#M542820 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>Product&amp;'-' as Part_No</P></BODY></HTML> Thu, 12 Jun 2014 09:29:29 GMT Anonymous 2014-06-12T09:29:29Z How to make BC9000 display as BC9000_ ? https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666486#M542817 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>I like to add the under score on the Product Name., For example</P><P>C9000-H119 become C9000-H119_</P><P>CX1900-0320 become CX1900-0320_</P><P></P><P></P><P>My existing code now is below :-</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Product as [PART_NO_],</P><P></P><P></P><P>I imagine it should be some thing like this :-</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Product as [PART_NO_],</P><P></P><P></P><P>&nbsp; Product&amp;'_' as [PART_NO_],</P><P></P><P></P><P></P><P></P><P>But it does not work.</P><P></P><P></P><P>Paul</P></BODY></HTML> Thu, 12 Jun 2014 09:23:41 GMT https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666486#M542817 paulyeo11 2014-06-12T09:23:41Z Re: How to make BC9000 display as BC9000_ ? https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666487#M542818 <HTML><HEAD></HEAD><BODY><P>This is my QV doc.</P></BODY></HTML> Thu, 12 Jun 2014 09:27:56 GMT https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666487#M542818 paulyeo11 2014-06-12T09:27:56Z Re: How to make BC9000 display as BC9000_ ? https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666488#M542819 <HTML><HEAD></HEAD><BODY><P>Hi Paul,</P><P></P><P>say your fieldname (in the script) is &gt; product_id &lt;</P><P>=&gt; Then, in the LOAD (script) you would go</P><P>LOAD</P><P>&nbsp; ....</P><P>&nbsp; ....</P><P>&nbsp; product_id &amp; '_' as product_ID</P><P>FROM ...</P><P>(so you would concatenate the actual contents of the field and an underscore)</P><P>HTH</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Thu, 12 Jun 2014 09:28:12 GMT https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666488#M542819 datanibbler 2014-06-12T09:28:12Z Re: How to make BC9000 display as BC9000_ ? https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666489#M542820 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>Product&amp;'-' as Part_No</P></BODY></HTML> Thu, 12 Jun 2014 09:29:29 GMT https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666489#M542820 Anonymous 2014-06-12T09:29:29Z Re: How to make BC9000 display as BC9000_ ? https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666490#M542821 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> Product&amp;'_' as Product</SPAN></P></BODY></HTML> Thu, 12 Jun 2014 09:29:57 GMT https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666490#M542821 MK_QSL 2014-06-12T09:29:57Z Re: How to make BC9000 display as BC9000_ ? https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666491#M542822 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>Yes it work , thank.</P><P></P><P>Paul</P></BODY></HTML> Thu, 12 Jun 2014 09:35:44 GMT https://community.qlik.com/t5/QlikView/How-to-make-BC9000-display-as-BC9000/m-p/666491#M542822 paulyeo11 2014-06-12T09:35:44Z