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: 
Not applicable

Drill Down List for Straight Tables

Hi,

I am a new user of QlikView.

I have a created a straight table that looks like below.

Manager 1PopulationLearning PlanNo Learning PlanLearning Plan Completion
Smith100050050050%

Manger 1 is the Dimension and other fields are expressions.

I want to create a drill down list i.e, when I click on 'Smith', it should take me to the next level of Managers reporting into Smith, lets call this dimension as Manager 2 and Manager 1 Column in the table should be hidden.

I have about 7 levels of Manager Dimension that needs to drilled through and only single column should be displayed in the straight table.

Could someone please help me with this?

Best Regards,

Varun.M

1 Solution

Accepted Solutions
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Settings > Document Properties > Groups.

There you can create a drill down or a cyclic groups:

Screenshot_2.jpg

Also instead of adding the simple dimension you have to add a newly created group that will appear in a dimensions' list.

View solution in original post

5 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Settings > Document Properties > Groups.

There you can create a drill down or a cyclic groups:

Screenshot_2.jpg

Also instead of adding the simple dimension you have to add a newly created group that will appear in a dimensions' list.

Not applicable
Author

Thank you so much!! this is super helpful

oknotsen
Master III
Master III

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!
Not applicable
Author

sorry I couldn't find the 'correct answer' flag. Hence marked it as helpful.

oknotsen
Master III
Master III

If you open the actual topic (instead of the preview in your inbox), you will see the "Correct Answer" button. It is huge and really hard to overlook.

May you live in interesting times!