Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MadhuriReddy
Contributor III
Contributor III

Drill down function issue in qlik sense

Hello,

 

I have issue with the drill down function, if I select a country then I have to get product fields as selection.

 

MadhuriReddy_1-1633507642127.png

 

If I select India in drill down then it has to show the reps in the respective country. ex: India is selected I have to get x.rep1,x.rep3, and y.rep2,y.rep3.y.rep2 vice versa as drill down. 

Help me out with the issue.

Thanks in advance

Regards,

Madhuri

1 Solution

Accepted Solutions
Andrea_Spinetti
Former Employee
Former Employee

Hi @MadhuriReddy ! A drill-down accesses data going by successively deeper levels of a hierarchically. Unfortunately in your case, if I got your request right, it won't be possible to create a drill-down master dimension since the fields "Product x" and "Product y" are at the same level of hierarchy. 

If the issue is solved please mark the answer with Accept as Solution.

View solution in original post

4 Replies
abhijitnalekar
Specialist II
Specialist II

Hi @MadhuriReddy ,

 

You can create  Drill-down Dimension from the Master dimension.

Add required fields in the fields.

 

abhijitnalekar_1-1633508450183.png

 

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
MadhuriReddy
Contributor III
Contributor III
Author

Thanks Abhijit for response, but I have to show 2 field values once in the drill down. I have a doubt like how can we get this two fields at a time when one value is selected. As I mentioned the example.

Regards,

Madhuri

 

Andrea_Spinetti
Former Employee
Former Employee

Hi @MadhuriReddy ! A drill-down accesses data going by successively deeper levels of a hierarchically. Unfortunately in your case, if I got your request right, it won't be possible to create a drill-down master dimension since the fields "Product x" and "Product y" are at the same level of hierarchy. 

If the issue is solved please mark the answer with Accept as Solution.
abhijitnalekar
Specialist II
Specialist II

Hi @MadhuriReddy ,

Yes that can't be possible the way I had suggest.

Can you please explain the scenario or exact requirement how you are going to this hierarchy.

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!