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.