Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Mathumitha,
What you can do is this:
This will create two links between the tables. Then you can create the bar chart and the drill down.
Jordy
Climber
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?
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