Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bernhard2760
Partner - Contributor III
Partner - Contributor III

Concatenate varying Hierarchy Columns if cell is not null

Dear Qlik Community,
I have a problem concatenating hierarchy columns.
First, I need a script that can cope with varying depths.
Second, I would like to see parentheses around the ID but only if there is a value in the column.
I need some sort of loop however I struggle to find the right approach.
The result should be like "(ID) Desc". I have enclosed the app.
Would highly appreciate some hints.

HierarchyDemo.png

Kind regards

Bernhard

Labels (1)
1 Reply
MarcoWedel

Can you elaborate on what your input data looks like and what your expected result would be?

What does "concatenating hierarchy columns" mean in this context?