Drill Down Bar Chart

[Mathumitha]

Hi all, I am new to Qlik Sense .Can someone please suggest me the best way to solve this question

Description:

In “Data Source_Task3” excel file we have – Master Table, Hierarchy Relationship Table, Employee Table.

Master Table – ID, Name and Division column.

Relationship Table – NodeID and Parent ID column.

Employee Table – PlaceID, Employee Count column.

Question:

Create a Hierarchy Drill down Bar Chart which displays employee count at each level.

The data set is given below

Data

[JordyWegman]

Hi Mathumitha,

What you can do is this:

1. Load all the tables
2. Rename NodeID to ID
3. Rename ParentID to PlaceID

This will create two links between the tables. Then you can create the bar chart and the drill down.

Jordy

Climber

[Mathumitha]

Hi JordyWegman,

              I tried but I am not able to get the required drill down bar chart. Can you please help me with the coding part?

[JordyWegman]

Hi,

If you created the keys and the data model is correct, you can create a drill-down this way:

Follow each step and you will have it.

Jordy

Climber