Macro for cyclic group

Thu, 22 Mar 2012 04:54:45 GMT

I have written this macro for a Cyclic group(GeoID) with Nation, REGION_ID, DISTRICT_ID and TERRITORY as the fields.

But it takes me one level down. Say if i am at Nation it will take me to REGION_ID and then DISTRICT_ID and then TERRITORY but i want to do it the other way. like from TERRITORY-->DISTRICT_ID-->REGION_ID-->Nation.

What can be the macro for that.

My macro is:

sub cyclic

set gp = ActiveDocument.GetGroup("GeoID")

do while gp.GetActiveField.Name = "DISTRICT_ID"

gp.cycle 1

loop

do while gp.GetActiveField.Name = "REGION_ID"

gp.cycle 1

loop

do while gp.GetActiveField.Name = "Nation"

gp.cycle 1

loop

end sub

topic Macro for cyclic group in QlikView

Macro for cyclic group