Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro for cyclic group

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

0 Replies