topic Folder hierarchy by pivot table failed to be selected in QlikView

Folder hierarchy by pivot table failed to be selected

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Folder hierarchy by pivot table failed to be selected

Anil_Babu_Samineni — Fri, 14 Oct 2016 08:34:15 GMT

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

Re: Folder hierarchy by pivot table failed to be selected

Fri, 14 Oct 2016 08:53:37 GMT

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

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

Re: Folder hierarchy by pivot table failed to be selected

Anil_Babu_Samineni — Fri, 14 Oct 2016 09:00:50 GMT

You might require this

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

Re: Folder hierarchy by pivot table failed to be selected

Fri, 14 Oct 2016 09:09:45 GMT

It doesn't make any different.

Re: Folder hierarchy by pivot table failed to be selected

el_aprendiz111 — Fri, 14 Oct 2016 16:22:50 GMT

1 Example