Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Drill down dimension behavior with single value

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. 

1 Solution

Accepted Solutions
awhitfield
Esteemed Contributor

Re: Drill down dimension behavior with single value

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

3 Replies
awhitfield
Esteemed Contributor

Re: Drill down dimension behavior with single value

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
Valued Contributor II

Re: Drill down dimension behavior with single value

Hi!

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

G.

Not applicable

Re: Drill down dimension behavior with single value

Thanks Andy, I appreciate the quick reply