Displaying Hierarchical Data in Text Box

vikraant — Sun, 19 Feb 2017 18:31:58 GMT

Greetings Everyone,

I am new to qlik and qlik community. I came across a requirement in which when selection is made in the hierarchical field the available values in the lower hierarchy had to be displayed in the text box . For example if there are two fields, viz, Brand and Parent-Brand hierarchy, When selection is made in Brand, text box should display all the distinct available fields in the Parent-Brand and vice versa.

One way I thought it could be done is using the Concat and Aggr function

=Concat(Distinct Aggr(Concat(Distinct Brand, ' '),Parent-Brand ), ' ' )

So if nothing is selected in the Parent-Brand, the above expression would display all the brands under the parent brand.

If you have faced similar requirements or any similar requirements please share your views in the comments. Also do check out the app attached with this showing

Thank You!

topic Displaying Hierarchical Data in Text Box in App Development

Displaying Hierarchical Data in Text Box