I am trying to create a tree map using a drill-down dimension with the following structure.
|Company||Business Function||Business Unit|
|Company ABC||BF A||BU 1|
|Company ABC||BF B||BU 2|
|Company ABC||BF B||BU 3|
The idea is for the user to see the measure calculated for Company ABC at a macro lens and then drill down to the respective Business Function / Units.
However, due to the first level of the drill-down having all the same values, Qlik Sense represents the tree-map using the second level (i.e. Business Function). Is there anyway to force Qlik Sense in using the first level?
Thanks in advance!