Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

help with database structure

Drill Down.JPG

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

Tags (2)
1 Solution

Accepted Solutions

help with database structure

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

View solution in original post

2 Replies

help with database structure

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

View solution in original post

Not applicable

help with database structure

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

drilldown2.JPG