topic Re: help with drill down in QlikView

help with drill down

Wed, 25 Nov 2020 16:16:04 GMT

‌

Hello ! I am trying to create a chart that drills down from industry to category.

Here is my chart:

https://gyazo.com/57deaf6e65d7140122b893f0b0a50b0b

But the problem is, when you click on any of the industry, (e.g. IT) instead of showing the categories in IT, it continues to show the industry instead:

https://gyazo.com/b84c3e2fd5a58b3e11d4642a965c3a69

How to i get it to show the categories under IT (i.e. Manufacturing and Services) instead of just showing IT as a bulk

Note: i have only used qlikview for about an hour and have to use it for an assignment, so please use simpler terms

Any help will be appreciated (:

edit:

here is the drill-down group: https://gyazo.com/cb87aa1ae419ee1c8f7d30aa0881eb05

here is the data i am using: https://gyazo.com/ba59c592a8172a789418c52199bed683

Re: help with drill down

kaushiknsolanki — Tue, 29 Nov 2016 18:08:16 GMT

Hi,

Hope you have first created the drill down group and then added that as a dimension.

Regards,

Kaushik Solanki

Re: help with drill down

rupamjyotidas — Tue, 29 Nov 2016 18:26:01 GMT

Hope you are using the Industry(Drill Down) Field as Dimension instead of just Industry Field.

Re: help with drill down

Tue, 29 Nov 2016 19:00:07 GMT

Hi Jodie,

As per the images I see you are not using the drill down group in "Chart properties >Dimensions tab >Used Dimensions" Can you verify that.

-Ashok

Re: help with drill down

MarcoWedel — Tue, 29 Nov 2016 22:53:36 GMT

Hi,

I guess the reason for this behaviour is that you used a group name that already existed as field name (Industry).

QlikView doesn't seem to like this ambiguity:

When selecting a group as dimension in a chart, the icon next to the group name in the "Used Dimensions" section of the Dimensions tab suggests a group, while the icon disappears after closing and reopening the properties if there exists a field with the same name. Adding a group to the "Used Dimensions" section also deletes fields sharing the same name from the "Available Fields/Groups" list.

reopened:

So long story short: rename your group:

hope this helps

regards

Marco