Drill Down | Show next level of hierarchy

[thkarner]

Hi,

I´ve a given company structure as unbalanced tree:

The speciality is, that I´ve precalculated values for each node. This means there should be NO aggregation (e.g. sum) from the sub-level.

Given this, the requirements in the Qlik Sense app are:

a) It should be possible to drill-down from level to level

b) Only the next sub-level based on the current selection should be displayed

c) Only the values available for the elements of the next sub-level should be summarized, without summing up values from the lower levels

I could achieve this in a QlikView app by the help of the hierarchy in a list box. If I select a single node in this list box, I get the values for the next lower level.

I tried the same in Qlik Sense (with same data model) by the help of a drill-down master element, but failed because the behaviour of drill-down is different than of a hierarchy list box in QlikView.

How can I achieve this in Qlik Sense?

See sample apps in QS and QV!

Thanks for your help in advance,

Thomas

[ericasense]

Hi Thomas, the drill-down and summaries are working fine for me. Can you elaborate on what you are finding?

PS if you are able to use extensions, there are some dynamic tree extensions on QlikBranch that you might want to try working with? EG http://branch.qlik.com/#!/project/56728f52d1e497241ae697f0 and http://branch.qlik.com/#!project/578ef4b5171e912050d4133d

[zebhashmi]

can you share Qlikview snapshot what you are looking for

[thkarner]

What do you mean with QlikView snapshot?

I´ve already attached the (reloadable) QlikView document as well as the Qlik Sense app ...

[zebhashmi]

yes but i can't open that

sorry for that!

[thkarner]

QVW is for QlikView 12

QVF is for Qlik Sense November Release (to be copied into ..Documents\Qlik\Sense\Apps in case of Qlik Sense Desktop or to be imported via QMC in Qlik Sense Server)

[thkarner]

Hi Erica,

if I select a certain node in QlikView like OMIAL ...

... the table shows me all direct elements of the next level with their values.

Notice that M621 and PPSGA (from the lowest level) are not shown in the table and are not considered in the calculation. This is because the hierarchy selection in the list box only selects a certain path in the hierarchy table.

I want to have this or similar behaviour also in Qlik Sense, but with the Drill-Down in Qlik Sense I couldn´t achieve this, because it selects always all nodes below the current selection. Maybe I need to change the datamodel somehow ...?

Regards, Thomas

PS: Thanks for the link to the 2 extensions. Unfortunately they are visualizing the whole tree and use a lot of space on the canvas.

[ericasense]

Right, I get you, so you only need to show the nodes that are directly below? Probably the quickest and easiest way to achieve this is to set the dimension in the table to the drill down group itself, and maybe uncheck the "include null values" option to get rid of any nodes which don't have a value in that table.

Erica

[ericasense]

So use these settings:

To get this in the chart - you may need to rename the dimension name

Erica

[thkarner]

Sorry, but I can´t follow your solution. If already included the drill-down dimension in my table.

If I then select "AFP" and "OMIAL" (from the list box) ...

... all nodes below OMIAL are displayed in my table (but PPSGA and M621 shouldn´t).

In my case it doesn´t make a difference to check/uncheck "Include Null values" option.

How did you proceed only to see "PPS", "OMGA" and "M620" as shown in your screenshot?