Cyclic Group

Wed, 16 May 2012 12:49:19 GMT

I have a field called GeographyLevel.. That has Nation, Region, District and Territory in it.

I have other fields called Region_ID, District_ID and Territory_ID. when i click on Region in the GeographyLevel, list box with Region_ID field pops up. similarly for others.,

Now i have created a cyclic group called Geo_ID with Nation, Region_ID, District_ID and Territory_ID as its field.

My requirement is such that when i select Region_ID in the cyclic group list box. the list box with Geography level as its field should come to Region level.

similarly for District_ID it should come to District level.

I have attached the sample QVW file.

Please Help.

Cyclic Group

Wed, 16 May 2012 13:00:22 GMT

I am using Document event triggers.

On Any Select==>

Select In Field= [Geography Level]

Search String=

if(GetCurrentField([Geo_ID])='Region_ID', 'Region', if(GetCurrentField([Geo_ID])='District_ID', 'District', if(GetCurrentField([Geo_ID])='Territory_ID', 'Territory')))

but its not working

topic Cyclic Group in QlikView

Cyclic Group

Cyclic Group