Drill Down

Tue, 17 Apr 2012 08:25:11 GMT

I have a Drilldown group called "GeoLevel" with fields Nation, REGION_ID, DISTRICT_ID and TERRITORY. I have another list box with field [Geography Level] that has Nation, Region, District and Territory in it. I want to control the selection in such a way that if i drill down to REGION_ID in the drilldown group the [Geography Level] list box should be at Nation level. similarly if i go to TERRITORY in drill down group, [Geography Level] should be at District level again if i come up to DISTRICT_ID in the drill down the [Geography Level] filter should be at Region Level.

For that i created a variable called vGeoLevel with its value as

GetCurrentField([GeoLevel])

Now in triggers i have provided action to the variable OnInput "Select in Field"

Field= [Geography level]

Search String=

if(GetCurrentField([GeoLevel])='REGION_ID','Nation',
if(GetCurrentField([GeoLevel])='DISTRICT_ID','Region',
if(GetCurrentField([GeoLevel])='TERRITORY','District')))

On change also i have given the same action. Ideally it should work because i have done the same thing once with cyclic group. But i dont know why it is not working

Drill Down

v_iyyappan — Tue, 17 Apr 2012 09:46:52 GMT

Hi,

Cau u attach a sample application ?

regards,

Iyyappan

Re: Drill Down

sivarajs — Tue, 17 Apr 2012 09:54:15 GMT

use getselectedcount instead of getcurrentfield

Drill Down

Tue, 17 Apr 2012 11:14:01 GMT

getselectedcount does not work.

Re: Drill Down

sivarajs — Tue, 17 Apr 2012 13:16:43 GMT

Check the attached sample

topic Drill Down in QlikView

Drill Down

Drill Down

Re: Drill Down

Drill Down

Re: Drill Down