Drill down dimension behavior with single value

[#1]

Hi,

I'm using a drill down dimension to display data through an organizational hierarchy.  In the hierarchy there are 4 levels

Region

Business Unit

Cost Center

Personnel

My drill down dimension is set up this same way.  The issue I'm having is that if I have a Region with a single Business Unit when I select the Region as the value the drill down automatically goes to a list of Cost Centers, not the Business Unit.  If the Region has multiple Business Units then it appropriately drills down and displays a list of Business Units. 

[awhitfield · Accepted solution]

Hi Wayne,

It does work that way unfortunately, either create a dummy blank business unit OR use a cyclic group instead seemed to be the consensus last time this issue came up.

HTH Andy

[undergrinder]

Hi!

As far as i know in QlikSense there is no cyclic group.

G.

[#4]

Thanks Andy, I appreciate the quick reply

[prat1507]

Hi

Did you get any solution to this problem??

Regards

Pratyush