Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It looks like you have the actual "company" field rather than the drill down group. Otherwise I'm not sure
Erica
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!
I think you need a expression something like that
=Concat({1<UPID=P(Mother_UPID)>}[First Name],' - ',',')
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.
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