Switch between two different drilldown dimensions

[phuelish]

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

[passionate]

Why don't you try two different objects to handle different drill down options.
hide and show objects based on condition.

[phuelish]

Thanks Pankaj,

I've used conditional show in QlikView, but not in Qlik Sense (server)...I'll have to figure out how to do this, as it doesn't appear to be a default option in the visualizations I am using.

-Frank

[phuelish]

Hi Panjak,

I did some checking around and can't seem to find a show condition for the object I am using...I can use the conditional calculation, but I'm attempting to modify based on dimensions. From what I've read, I'll need to build an array with the dimensions and measures in the script in order to do this.

Since I'm not the most technical person, I've instead decided to set up two sheets; one for geographic and one for organizational structure. I'll use navigation buttons to send the user to the correct view...just need to make sure I build in a back button and consider how to ensure the filters are cleared when moving back to the overview. Since this is getting off topic, please do not feel obliged to respond.

thanks again for your help.

-Frank