Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am a new user of QlikView.
I have a created a straight table that looks like below.
Manager 1 | Population | Learning Plan | No Learning Plan | Learning Plan Completion |
---|---|---|---|---|
Smith | 1000 | 500 | 500 | 50% |
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
Settings > Document Properties > Groups.
There you can create a drill down or a cyclic groups:
Also instead of adding the simple dimension you have to add a newly created group that will appear in a dimensions' list.
Settings > Document Properties > Groups.
There you can create a drill down or a cyclic groups:
Also instead of adding the simple dimension you have to add a newly created group that will appear in a dimensions' list.
Thank you so much!! this is super helpful
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 .
sorry I couldn't find the 'correct answer' flag. Hence marked it as helpful.
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.