Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
florentina_doga
Partner - Creator III
Partner - Creator III

macro to reset a circular group to a default value

hi guys

I need a macro to reset a circular group to a default value.

I have 20 circular groups of different sizes. I need a macro to reset these groups to ALL.

All is also a fictitious dimension added to all these circular groups

Thank you in advance

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

This should work for one group:

sub SetGroup

  set gp = ActiveDocument.GetGroup("YourGroupName")

  strField = activedocument.evaluate("=GetCurrentField([YourGroupName])")

  do while left(strField,3) <> "ALL"

  gp.Cycle 1

  Application.Refresh

  strField = activedocument.evaluate("=GetCurrentField([YourGroupName])")

  loop

end sub

View solution in original post

1 Reply
m_woolf
Master II
Master II

This should work for one group:

sub SetGroup

  set gp = ActiveDocument.GetGroup("YourGroupName")

  strField = activedocument.evaluate("=GetCurrentField([YourGroupName])")

  do while left(strField,3) <> "ALL"

  gp.Cycle 1

  Application.Refresh

  strField = activedocument.evaluate("=GetCurrentField([YourGroupName])")

  loop

end sub