topic Re: Highest level drill down group in QlikView

Highest level drill down group

rudywelvaert — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I made a drill down group with 4 levels:

highest level: Organization

second level: Region

third level: Team

lowest level: Team member

The question is: Why can't I get to the highest level in the drill down to show the total for the whole organization.

I can only go to the second, third and lowest level.

I attach a simplified example Drill_Down_Group.qvw

Thanks for any help

m_woolf — Mon, 14 Mar 2016 17:36:09 GMT

This is from the Ref Manual:

When a drill-down group is used as a dimension in a chart, the chart will use the first Fields (page 167) in

the group's list of fields that has more than one possible value. If selections are made that cause the field to

have only one possible value, the next field in the list will be used instead, provided that it has more than

one possible value. If no field in the list has more than one possible value, the last field will be used anyway.

If you change to a Cyclic Group it will work.

rudywelvaert — Tue, 15 Mar 2016 08:02:52 GMT

Thanks m w

That is what I suspected.

I tried the cyclic group and it works.

Thanks again