topic macro to reset a circular group to a default value in QlikView

macro to reset a circular group to a default value

florentina_doga — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: macro to reset a circular group to a default value

m_woolf — Thu, 15 Jun 2017 16:51:25 GMT

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