I want to create a drill down dashboard in QlikView

[#1]

For each level there is a separate table in SQL which is the source data. The hierarchy is as follows: WW->Region->Sub-Region->Manager->Sales Rep->Transaction. So for e.g., if the WW manager logs in he will be able to see the data from top level, similarly if the sub-region manager logs in he can view the data from sub-region and below and so on.

WW

1. AMS
   1. Canada
      1. Sales Manager
         1. Sales Rep
            1. Transaction1
            2. Transaction2
   2. USA
      1. Sales Manager
         1. Sales Rep
            1. Transaction1
            2. Transaction2
   3. LATAM
      1. Sales Manager
         1. Sales Rep
            1. Transaction1
            2. Transaction2
2. APJ
   1. ASEAN
      1. Sales Manager
         1. Sales Rep
            1. Transaction1
            2. Transaction2
   2. India
      1. Sales Manager
         1. Sales Rep
            1. Transaction1
            2. Transaction2
   3. Japan
      1. Sales Manager
         1. Sales Rep
            1. Transaction1
            2. Transaction2
3. EMEA
   1. CEE
      1. Sales Manager
         1. Sales Rep
            1. Transaction1
            2. Transaction2
   2. Germany
   3. Iberia
   4. Italy

[tresesco]

Go through http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization

[Gysbert_Wassenaar]

Can you post a document with sample data? See this document: Preparing examples for Upload - Reduction and Data Scrambling