topic help with database structure in QlikView

help with database structure

Wed, 06 Jun 2012 15:10:03 GMT

Good morning! I have a problem
I need to do a chart type drill down to the previous data table structure
The drill down would be of two types:
* country -> region -> customer

* country -> customer

any ideas?
thanks

help with database structure

Miguel_Angel_Baeyens — Wed, 06 Jun 2012 15:16:53 GMT

Hi,

Go to the Settings menu, Document Properties, Groups and create a new drill down group. Add the dimensions Country, Region and Customer and save it.

When you create the chart, you will see how this group (preceded by an arrow icon) can be used so when you click on any country, you drill down to its regions, and when you click on a region, the chart drills down to its customers.

Hope that helps.

Miguel

help with database structure

Wed, 06 Jun 2012 15:44:02 GMT

The new structure of the database is the following
leave as null the names of the missing areas
and drill down works perfectly in the dashboard
thank you very much