topic Re: Concatenation in UI part in QlikView https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390992#M422912 <HTML><HEAD></HEAD><BODY><P>This?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180132_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 18 Oct 2017 15:13:28 GMT Anil_Babu_Samineni 2017-10-18T15:13:28Z Concatenation in UI part https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390984#M422904 <HTML><HEAD></HEAD><BODY><P>Hi team,</P><P></P><P>I am using straight chart. I need to merge two fields into one as an attachment. </P><P></P><P>I am using below but it is not working:</P><P></P><P>TYPE&amp;''&amp;CODE</P><P></P><P>Can anyone help me out there?</P></BODY></HTML> Wed, 18 Oct 2017 12:58:03 GMT https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390984#M422904 vipingarg23 2017-10-18T12:58:03Z Re: Concatenation in UI part https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390985#M422905 <HTML><HEAD></HEAD><BODY><P>Hi Vipin,</P><P></P><P>=Type &amp; Code</P><P></P><P>works. Remember QV is case sensitive.</P><P></P><P>Regards</P><P></P><P>Andrew</P></BODY></HTML> Wed, 18 Oct 2017 14:22:50 GMT https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390985#M422905 effinty2112 2017-10-18T14:22:50Z Re: Concatenation in UI part https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390986#M422906 <HTML><HEAD></HEAD><BODY><P>It is not working as well. It is giving me wrong result as previous.</P></BODY></HTML> Wed, 18 Oct 2017 14:39:13 GMT https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390986#M422906 vipingarg23 2017-10-18T14:39:13Z Re: Concatenation in UI part https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390987#M422907 <HTML><HEAD></HEAD><BODY><P>Can you share an image to show the issue?</P></BODY></HTML> Wed, 18 Oct 2017 14:40:16 GMT https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390987#M422907 sunny_talwar 2017-10-18T14:40:16Z Re: Concatenation in UI part https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390988#M422908 <HTML><HEAD></HEAD><BODY><P>Please find the attached file.</P><P> It is showing right data for value south and west but not for EAST as I have multiple value for the EAST.</P></BODY></HTML> Wed, 18 Oct 2017 14:55:24 GMT https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390988#M422908 vipingarg23 2017-10-18T14:55:24Z Re: Concatenation in UI part https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390989#M422909 <HTML><HEAD></HEAD><BODY><P>Hi Vipin,</P><P></P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH><SPAN style="color: #363636;"><STRONG>A</STRONG></SPAN><STRONG> </STRONG></TH><TH><SPAN style="color: #363636;"><STRONG>B</STRONG></SPAN><STRONG> </STRONG></TH><TH><SPAN style="color: #363636;"><STRONG>C</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>A &amp; B &amp; C</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">EAST</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DT</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">001</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">EASTDT001</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">EAST</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DT</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">002</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">EASTDT002</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">SOUTH</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">CT</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">007</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">SOUTHCT007</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WEST</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BT</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">005</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WESTBT005</SPAN></TD></TR></TBODY></TABLE><P></P><P>?</P></BODY></HTML> Wed, 18 Oct 2017 15:00:08 GMT https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390989#M422909 effinty2112 2017-10-18T15:00:08Z Re: Concatenation in UI part https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390990#M422910 <HTML><HEAD></HEAD><BODY><P>But I don't want to merge column A</P></BODY></HTML> Wed, 18 Oct 2017 15:07:36 GMT https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390990#M422910 vipingarg23 2017-10-18T15:07:36Z Re: Concatenation in UI part https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390991#M422911 <HTML><HEAD></HEAD><BODY><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH><SPAN style="color: #363636;"><STRONG>A</STRONG></SPAN><STRONG> </STRONG></TH><TH><SPAN style="color: #363636;"><STRONG>B</STRONG></SPAN><STRONG> </STRONG></TH><TH><SPAN style="color: #363636;"><STRONG>C</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>B &amp; C</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">EAST</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DT</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">001</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DT001</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">EAST</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DT</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">002</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">DT002</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">SOUTH</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">CT</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">007</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">CT007</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">WEST</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BT</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">005</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BT005</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 18 Oct 2017 15:11:48 GMT https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390991#M422911 effinty2112 2017-10-18T15:11:48Z Re: Concatenation in UI part https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390992#M422912 <HTML><HEAD></HEAD><BODY><P>This?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180132_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 18 Oct 2017 15:13:28 GMT https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390992#M422912 Anil_Babu_Samineni 2017-10-18T15:13:28Z Re: Concatenation in UI part https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390993#M422913 <HTML><HEAD></HEAD><BODY><P>It worked now.&nbsp; I am creating adhoc report So those field weer not my dimensions. I add those fields in my dimension and hide them. </P><P></P><P>Please let me know if any other efficient way that I should use.</P></BODY></HTML> Wed, 18 Oct 2017 15:14:21 GMT https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390993#M422913 vipingarg23 2017-10-18T15:14:21Z Re: Concatenation in UI part https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390994#M422914 <HTML><HEAD></HEAD><BODY><P>Great Anil. It is fine now. I was using in expression that's why I need to hide the column. If use this in dimension then I don't need to hide the columns. Good Solution. Thanks for help.</P></BODY></HTML> Wed, 18 Oct 2017 15:18:05 GMT https://community.qlik.com/t5/QlikView/Concatenation-in-UI-part/m-p/1390994#M422914 vipingarg23 2017-10-18T15:18:05Z