Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?