https://community.qlik.com/t5/App-Development/Concatenate-varying-Hierarchy-Columns-if-cell-is-not-null/m-p/1880517#M72562 <P>Dear Qlik Community,<BR />I have a problem concatenating hierarchy columns.<BR />First, I need a script that can cope with varying depths.<BR />Second, I would like to see parentheses around the ID but only if there is a value in the column. <BR />I need some sort of loop however I struggle to find the right approach.<BR />The result should be like "(ID) Desc". I have enclosed the app. <BR />Would highly appreciate some hints.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HierarchyDemo.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/70128i4B4D2C702B2FCC3E/image-size/medium?v=v2&amp;px=400" role="button" title="HierarchyDemo.png" alt="HierarchyDemo.png" /></span></P> <P>Kind regards</P> <P>Bernhard</P> Thu, 13 Jan 2022 08:56:49 GMT bernhard2760 2022-01-13T08:56:49Z https://community.qlik.com/t5/App-Development/Concatenate-varying-Hierarchy-Columns-if-cell-is-not-null/m-p/1880517#M72562 <P>Dear Qlik Community,<BR />I have a problem concatenating hierarchy columns.<BR />First, I need a script that can cope with varying depths.<BR />Second, I would like to see parentheses around the ID but only if there is a value in the column. <BR />I need some sort of loop however I struggle to find the right approach.<BR />The result should be like "(ID) Desc". I have enclosed the app. <BR />Would highly appreciate some hints.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HierarchyDemo.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/70128i4B4D2C702B2FCC3E/image-size/medium?v=v2&amp;px=400" role="button" title="HierarchyDemo.png" alt="HierarchyDemo.png" /></span></P> <P>Kind regards</P> <P>Bernhard</P> Thu, 13 Jan 2022 08:56:49 GMT https://community.qlik.com/t5/App-Development/Concatenate-varying-Hierarchy-Columns-if-cell-is-not-null/m-p/1880517#M72562 bernhard2760 2022-01-13T08:56:49Z https://community.qlik.com/t5/App-Development/Concatenate-varying-Hierarchy-Columns-if-cell-is-not-null/m-p/1880913#M72591 <P>Can you elaborate on what your input data looks like and what your expected result would be?</P> <P>What does "<SPAN>concatenating hierarchy columns" mean in this context?</SPAN></P> Thu, 13 Jan 2022 20:20:36 GMT https://community.qlik.com/t5/App-Development/Concatenate-varying-Hierarchy-Columns-if-cell-is-not-null/m-p/1880913#M72591 MarcoWedel 2022-01-13T20:20:36Z