2 Replies Latest reply: Nov 6, 2013 7:48 AM by Gysbert Wassenaar RSS

    I want to create a drill down dashboard in QlikView

      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