Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser22
Creator II
Creator II

Drill down (Hierarchy) in graphs

Hi

 

I am trying to load a table and map against a unique key which has product level details. I am trying to show the stock details in various level. 

For example: The beflow graph(left) shows the product A as 30301. The same product (right side graph) is subdivided into A1,A2,A3 with values 10000 each. But I am not able to do that. 

qlikuser22_0-1667909789164.png

The table is created like 

Table1:

Load

product ID,

custname,

prod_type,

..

..

..

from qvd;

 

Table2:

Load

productID,

level1,

level2,

level3,

level4,

level5,

area

from qvd;

 

 

Any ideas please. 

 

Labels (4)
2 Replies
Vishal_Gupta
Partner - Creator
Partner - Creator

Hi @qlikuser22 try creating a master dimension and select drill down option in it.

Select the dimension you want in drill hierarchy.

then use this master dimension in your visualisations

See below figure

Vishal_Gupta_0-1667928793132.png

 

If a post helps to resolve your issue, please accept it as a SOLUTION and leave a LIKE!
qlikuser22
Creator II
Creator II
Author

Hi @Vishal_Gupta 
Thanks for the reply! I tried something like that. I didn't work. I still get the same results. Any ideas please