Tree Map Issue - Drill-down with top dimension having a single value
Hi all,
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?