Groups - how to force a group level to display even if it only has one value

[#1]

I have a hierarchy which has been created as a drill down group. My users are asking where some of the expected hierarchy levels have gone to when certain selections (higher up) have been made. After investigation, the selections made lead to there being only one value at a certain level of the hierarchy, and QlikView skips the level completely and goes to the next level down.

Make it stop!

How do I force it to display all the levels of the drill down group regardless?

Russell

[yblake · Accepted solution]

if users accept that, change from "drill down" to "cyclic" group.

I really prefer cyclic groups because you can do multialues drills, and decide yourself of the hierachy steps, this is really powerfull.

But cyclic groups do not drill automatically when selecting a value.

[disqr_rm]

And if it is hard to get user acceptance, as usual, enclosed example should do the trick.

Hope it helps. Let us know if it did by validating the thread.

Thanks, Rakesh

[#4]

Your attachment demonstrated exactly what I am trying to avoid. The only way I can see to force a group to display all levels is to change it to a cyclic group rather than a drilldown group (thanks Yves for that one). Alternatively, you could "create" null data for all the permutations for all the levels to ensure that each variable is fully expanded at each level, but this seems like a sledgehammer to crack a nut, as it were.