Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thkarner
Partner - Creator III
Partner - Creator III

Drill Down | Show next level of hierarchy

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

14 Replies
ericasense
Contributor III
Contributor III

It looks like you have the actual "company" field rather than the drill down group. Otherwise I'm not sure

Erica

thkarner
Partner - Creator III
Partner - Creator III
Author

Hi, yes, I had the wrong field. Sorry, my fault.

Using the Drill-Down master item in the table solves only to see the next level. Fine!

The downside of this is, that now the figures are not correct.

I get

Values for M620 and OMGA are ok.

PPS is not ok and should display 920, which means only to show data for the node PPS. Subsequent nodes (M621 and PPSGA) should NOT be included in the sum!

That´s in total what I tried to realise, but was´t lucky until now.

Thanks for your support!

zebhashmi
Specialist
Specialist

I think you need a expression something like that

=Concat({1<UPID=P(Mother_UPID)>}[First Name],' - ',',')

thkarner
Partner - Creator III
Partner - Creator III
Author

I think I´ve solved it.

I´m displaying the field "Company" in the table. This field is not part of the drill down, but contains all nodes below current selection in the hierarchy.

In the measure I´m using an additional set analysis like:

Sum( {<Level={$(=Min(Level))}>} Value1)

This ensures to show companies of highest level dynamically based on current selection in the drill-down.

shkyanam
Contributor
Contributor

Hi, I came across similar use case to display the pre-aggregated amounts at each node of the hierarchy in a pivot. Can you please help me the rules you followed to resolve the same.

 

Thank you,

Shalini