Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
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.


Kind regards


Labels (1)
1 Reply

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?