3 Replies Latest reply: Jun 12, 2017 2:12 PM by Frank Casella RSS

    Switch between two different drilldown dimensions

    Frank Casella

      Hi all,

       

      I've got a question that's similar to the alternate states vs. drilldown dimensions posts I've come across on the board, but hopefully different enough that the answer is not the same (i.e., I'm not out of luck).

       

      I'm using Qlik Sense 3.1 and want to create a drill down that reflects the misalignment between our geography and our leadership structure. For example, we may be interested in looking at sales within a particular geographic state within a market area, or we may want to see the same information split by sales leader within the market area.  I've created something that works, but is clunky and slow...

       

      if(Drilldown='Geography',

      if(GetSelectedCount(State)=1,

           [Sales Associate],

              if(GetSelectedCount([Market Area])=1,

               State,

                  if([Market Area]='Canada',

                   Null(),

                      [Market Area]

                  )

              )

          ),

          if(GetSelectedCount([Sales Territory])=1,

           [Sales Associate],

              if(GetSelectedCount([VPA Name])=1,

               [Sales Territory],

                  if(GetSelectedCount([Market Area])=1,

                   [VPA Name],

                      if([Market Area]='Canada',

                    Null(),

                       [Market Area]

                      )

                  )

              )

          )

      )

       

       

      is there a way to create branches within a drilldown dimension or switch between drilldown dimensions using a variable? Just looking for a way to streamline this to minimize the load on the dashboard.

       

      Thanks for the help!

       

      -Frank