topic Re: Drill Down Level Inclusive Question in QlikView

Drill Down Level Inclusive Question

Fri, 12 Dec 2014 18:30:22 GMT

Hello,

I have a general inquiry regarding Drill Down Groups. My Current hierarchy is for a geography, where we drill from Area --> Region --> to Territory.

So here is what i would like to achieve:

When I drill into a particular Area, I see all of the Regions in that Area

Then when I drill into a given Region, I would like to see all of the Territories in that Area.

Is this possible?? Or are there any work around?

This is what I have so far, which is close, but does not achieve the desired effect:

=Sum({$< ProductId = {1}, IsMonth = {1}, RegionName = >} Qty)

Thank You!

Re: Drill Down Level Inclusive Question

saurabh5 — Fri, 12 Dec 2014 18:46:00 GMT

hi,

you can go to setting> document properties> groups

and create a new group with drill down group option then move the fields in used felds area as per your hierarchy and save it .

Now create any object using the new field which will be represented by a downwards arrow.

Regards

Re: Drill Down Level Inclusive Question

Fri, 12 Dec 2014 18:59:38 GMT

Thank you for your response.

So I already have a drill down group with these 3 fields in it. This is my dimension. And then

=Sum({$< ProductId = {1}, IsMonth = {1}, RegionName = >} Qty)

is my expression.

But is there anyway to achieve the effect that I am looking for?

Re: Drill Down Level Inclusive Question

rwunderlich — Fri, 12 Dec 2014 19:43:36 GMT

The DrillDown group should do it for you. But you have to stop removing the Region selection in your expression. Remove:

RegionName =

-Rob

Re: Drill Down Level Inclusive Question

saurabh5 — Fri, 12 Dec 2014 20:32:16 GMT

remove Region name from the existing set analysis.

-Saurabh

Re: Drill Down Level Inclusive Question

Fri, 12 Dec 2014 20:58:57 GMT

yes so I do not want to see all of the Territories in the Region, but all of the Territories in the Area

Re: Drill Down Level Inclusive Question

MarcoWedel — Fri, 12 Dec 2014 21:52:31 GMT

You're describing a cyclic group instead of a drill down group.

So just change your group from drill down to cyclic.

You would have to switch the dimension by clicking the cyclic group button though instead of clicking one region.

hope this helps

regards

Marco

Re: Drill Down Level Inclusive Question

Mon, 15 Dec 2014 16:32:35 GMT

So I think that what I would like to do is essentially a combination of a drill down and a cyclic.

Drill down from Area to Region

And then do some sort of cyclic with territory and region

Re: Drill Down Level Inclusive Question

rwunderlich — Mon, 15 Dec 2014 18:01:43 GMT

Make two groups:

Drill: Area, Regions

Cyclic: Territory, Region

Assign both Groups to chart Dimension. Use the conditional Dimension property to control which one is in use.

For the Drill: =count(DISTINCT Area) > 1

For the Cycle: =count(DISTINCT Area) = 1

-Rob