Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
phuelish
Contributor III
Contributor III

Switch between two different drilldown dimensions

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

3 Replies
passionate
Specialist
Specialist

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

phuelish
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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