topic Re: Hierarchy display in QlikView

Hierarchy display

vijaysahu2 — Wed, 25 Nov 2020 16:16:04 GMT

I have one data model table Hierarchy and its column has been used in list box filter. We have one chart which uses Manager as dimension.

Current behavior of this chart when any value selected in filter

1. Click on Vijay and this shows all managers under him in mode.

But I would like to display only his Immediate manager's info only

John, Kiran, Rob, Smith, Tara, Tom

This works fine when I click Kiran, Rob,Smith and Tara in mode. This only display their managers only.

How can I get the below presentation when I click on Vijay?

I have attached Qvw and excel file for data . Please suggest me what can I do to achieve this

Anil_Babu_Samineni — Tue, 08 Aug 2017 11:15:10 GMT

Like this? you are trying to achieve in Bar graph

vijaysahu2 — Tue, 08 Aug 2017 12:36:55 GMT

Yes Anil ..Similar way.. How can we do this?

Anil_Babu_Samineni — Tue, 08 Aug 2017 12:40:32 GMT

I did it like to get Manager. But, Informative is not correct because associative engine is not getting in your Data.

SubField(Hierarchy, '/', 2)

The possible solution may be this?

Sum({<Hierarchy = $:: Manager >} Measure)

Sum({<Hierarchy = P(Manager) >} Measure)

prma7799 — Tue, 08 Aug 2017 12:41:17 GMT

Please check this to achieve your output.