Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Drill Down Multiple Selection

Hello:

I have a drill down group the has the following heirarchy:

Nation

Region

State

Currently, if i drill into multiple regions, then I see onlyh the multiple regions.  I want to make such if I drill into multiple Regions, I see All of the States within those 2 regions.

Thank You For Your Help

1 Reply
Employee
Employee

Re: Drill Down Multiple Selection

Drill groups won't work that way, and a cycle will require 2 clicks.

To do this 'on click' you could include 2 dimensions (Region and Country) and conditionally show one or the other depending if 1 or more Regions have been selected

No Regions Selected

Capture1.PNG.png

One or more regions selected

Capture2.PNG.png

The settings are on the dimension tab on each dimension itself, here is the condition for 'Region'

Untitled.png

Region 'enable conditional' expression:   GetSelectedCount(REGION)=0

Country 'enable conditional'  expression:   GetSelectedCount(REGION)>0

Community Browser