Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Bernhard
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?