Folder hierarchy by pivot table failed to be selected

[#1]

I am creating a list box of the following to show the ‘node’ that is selected. I have attached the qlikview file.

The node selection will look like the folder structure like the following pivot table.

 

However, this is only work when I click at the side like the following:

 

The ‘Europe’ node will be displayed

This will not work when I click on the ‘Europe’ text like the following

After clicking it doesn’t select the node of Europe

 

[Anil_Babu_Samineni]

I don't have license. Would you share me the Condition Expression what you written Overthere

[#3]

For list box title:

= [Business Unit P] & '/' & [Business Unit C1] & '/' & [Business Unit C2]

For pivot table there is no expression, just from the instruction of

Unbalanced, n-level hierarchies

====================

Henric Cronström a 27-Nov-2013 15:24 (in response to Dipti Desai d)

The pivot table is easy to make:
•Create a pivot table with Node1..Node7 as dimensions.
•Make the dimension columns narrower.
•On Properties - Style, check the "Indent Mode"
•Also check the "Use only first dimension label"
•Uncheck "Vertical Dimension Cell Borders"
•On Properties - Presentation, check the "Subtotals on Top"

Done!

HIC

====================

[Anil_Babu_Samineni]

You might require this

= [Business Unit P] & '/' & FieldValue(Concat([Business Unit C1], '/', Chr(10))) & '/' & FieldValue(Concat([Business Unit C2], '/', Chr(10)))

[#5]

It doesn't make any different.

[el_aprendiz111]

Hi

1 Example