topic Re: Help understanding drill-down group in QlikView

Help understanding drill-down group

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

Hi all

Sorry for the very basic question, and I have searched for the answer, honestly!

I have created a drill down group which is office name and staff name. I have a table set up showing various expressions by office and my plan is to have the table switch to staff name and show all the staff within the selected office.

At the moment, all that happens is the sheet is filtered by the office you select.

I am sure I am missing something very straight forward, and sorry again for the silly question!

Thanks

Re: Help understanding drill-down group

krishnacbe — Thu, 25 Aug 2016 13:53:17 GMT

Hi,

Drill down group will select that particular Office if you click on it. this is the default behavior.

simple example

Geo -> Country -> State -> City

On clicking the Geo data particular value will be selected and drilled down to Country level .

Hope this helps.

Re: Help understanding drill-down group

Anonymous — Thu, 25 Aug 2016 13:56:37 GMT

Sorry, I still don't really understand. Does that mean I cant do the drill down by office as the default is to select it as a filter, or have I just set up the group incorrectly?

Re: Help understanding drill-down group

beck_bakytbek — Thu, 25 Aug 2016 14:05:04 GMT

Hi Paul,

check this: QlikView | Expressions | Drill Down - YouTube

i hope that helps

beck

Re: Help understanding drill-down group

beck_bakytbek — Thu, 25 Aug 2016 14:22:05 GMT

Hi Paul,

check this:

What is the difference between drill down group and cyclic group?

Re: Help understanding drill-down group

krishnacbe — Thu, 25 Aug 2016 14:32:07 GMT

Drill down group will select the particular value.

If you want to view particular office details then on clicking on that it should select that Office. if you clear the selection it will come back to its original top layer.

No grouping incorrect. That is Drill down group behavior.

If you want to view all the office details then you should use Cycle group. But here you cant identify which staff is from which office.

Re: Help understanding drill-down group

Anonymous — Thu, 25 Aug 2016 14:45:36 GMT

When I click on say, "London", all that happens is the table changes and only shows "London" on one line with a Total. In other words, it doesn't do anything except remove all the other offices. What I want it to do is when I click on London, it changes dimension to 'Staff' and shows the staff relevant to "London".

That is my understanding of a drill down.

I suppose what I need to know is, is my understanding wrong or is my workbook wrong?!

Thanks

Re: Help understanding drill-down group

suresh_qv50 — Thu, 25 Aug 2016 14:47:13 GMT

Hi Paul,

Drill down group:

For example if you create group with office name and Staff Name and then used in a table instead of dimension

Initially the Table shows all the data belongs to Office Name(Dimension), When ever you click on any one of the Category from Office Name, Then the table show for Staff Name(Dimension) , Staff Name Data Corresponds to that specific category selected in Office Name.

First Displays : Office Name -- >if u select any Category -->Staff Name Data Appears(Only for category selected in Office Name)

In Cyclic Group, it has list of Dimension like Office Name and Staff Name, You can either select Office Name or Staff Name. You Cannot Get any Hire achy in Cyclic Group.

Hope This Helps..!

Re: Help understanding drill-down group

Anonymous — Thu, 25 Aug 2016 15:01:55 GMT

Ah ha. Then I have done something wrong!

Here is an example of my table.,

And here's what happens when I click on it

Where I would expect to see the names of the staff who work in Bristol!

Any ideas what could be wrong?

Re: Help understanding drill-down group

krishnacbe — Thu, 25 Aug 2016 16:10:53 GMT

Can you share the application or share the group details (Screenshot)

Re: Help understanding drill-down group

suresh_qv50 — Thu, 25 Aug 2016 17:38:55 GMT

Share the group details screen shots, it will be helpful to find the solution

Re: Help understanding drill-down group

Anonymous — Tue, 30 Aug 2016 08:16:23 GMT

Here is the group set up..

Re: Help understanding drill-down group

suresh_qv50 — Tue, 30 Aug 2016 15:14:54 GMT

Hi Paul,

Grouping was right, Its better to share sample app to better understand the problem.

Re: Help understanding drill-down group

agomes1971 — Tue, 30 Aug 2016 15:20:08 GMT

Hi,

here's a sample of a drill-down group.

HTH

André Gomes

Re: Help understanding drill-down group

Anonymous — Wed, 31 Aug 2016 13:23:18 GMT

Hi all.

I have located the problem! My workbook is setup with a different Alternate state on each sheet - basically each sheet contains very different metrics. When I switched the Alternate state back to "Inherited", the drill down worked.

Is there anyway around this do you think?

Many thanks

Re: Help understanding drill-down group

suresh_qv50 — Thu, 01 Sep 2016 04:25:10 GMT

Hi Paul,

Drill down group is not work in the alternate state..