topic Re: Concatenate fields in a hierarchy in QlikView https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578102#M214970 <HTML><HEAD></HEAD><BODY><P>I have managed to do it within the app as that was easier.&nbsp; </P></BODY></HTML> Thu, 27 Feb 2014 11:40:00 GMT 2014-02-27T11:40:00Z Concatenate fields in a hierarchy https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578096#M214964 <HTML><HEAD></HEAD><BODY><P>&nbsp;&nbsp;&nbsp;&nbsp; Hi </P><P></P><P>I have created a dim table based on hierarcy tag.&nbsp; Is it possible to concatenate two fields so I can display the code and description.</P><P></P><P></P><P>Thanks</P></BODY></HTML> Thu, 27 Feb 2014 11:11:58 GMT https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578096#M214964 2014-02-27T11:11:58Z Re: Concatenate fields in a hierarchy https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578097#M214965 <HTML><HEAD></HEAD><BODY><P>use code<STRONG>&amp;' '&amp;</STRONG>description as Code</P></BODY></HTML> Thu, 27 Feb 2014 11:24:06 GMT https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578097#M214965 2014-02-27T11:24:06Z Re: Concatenate fields in a hierarchy https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578098#M214966 <HTML><HEAD></HEAD><BODY><P>Thanks. Would this be in the load statement?</P></BODY></HTML> Thu, 27 Feb 2014 11:26:10 GMT https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578098#M214966 2014-02-27T11:26:10Z Re: Concatenate fields in a hierarchy https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578099#M214967 <HTML><HEAD></HEAD><BODY><P>Yes.</P><P></P><P>You can also do this in front end depends on your requirement.</P></BODY></HTML> Thu, 27 Feb 2014 11:28:55 GMT https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578099#M214967 2014-02-27T11:28:55Z Re: Concatenate fields in a hierarchy https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578100#M214968 <HTML><HEAD></HEAD><BODY><P>This is what I have and you will note I have put the concatenate in the Load statement&nbsp; but it fails load. </P><P></P><P>Hierarchy (LocalServiceLine, LocalServiceLineParent, LocalServiceLineDescription, , LocalServiceLineDescription,'\', 'HIEARACHY DEPTH')</P><P>LOAD LocalServiceLine &amp; ''&amp; LocalServiceLineDescription AS Line, </P><P>&nbsp; LocalServiceLineParent,</P><P>&nbsp; LocalServiceLineDescription</P><P>&nbsp; Resident DIMLocalServiceLine;</P><P>&nbsp; Drop table DIMLocalServiceLine;</P><P></P><P></P><P>RENAME Fields LocalServiceLineDescription1&nbsp; to Trust, LocalServiceLineDescription2 to Division, LocalServiceLineDescription3 to Specialty;</P></BODY></HTML> Thu, 27 Feb 2014 11:31:17 GMT https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578100#M214968 2014-02-27T11:31:17Z Re: Concatenate fields in a hierarchy https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578101#M214969 <HTML><HEAD></HEAD><BODY><P>Can you share QVW</P></BODY></HTML> Thu, 27 Feb 2014 11:36:28 GMT https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578101#M214969 2014-02-27T11:36:28Z Re: Concatenate fields in a hierarchy https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578102#M214970 <HTML><HEAD></HEAD><BODY><P>I have managed to do it within the app as that was easier.&nbsp; </P></BODY></HTML> Thu, 27 Feb 2014 11:40:00 GMT https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578102#M214970 2014-02-27T11:40:00Z Re: Concatenate fields in a hierarchy https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578103#M214971 <HTML><HEAD></HEAD><BODY><P>How can i share the QVW</P></BODY></HTML> Thu, 27 Feb 2014 11:58:16 GMT https://community.qlik.com/t5/QlikView/Concatenate-fields-in-a-hierarchy/m-p/578103#M214971 2014-02-27T11:58:16Z