topic Cyclic Group in QlikView

Cyclic Group

Thu, 05 Mar 2015 16:29:10 GMT

A bit of technical know how is needed on this one.

I have a Cyclic Group with a list of fields what I am after is when my client returns to the main page via a Button I need my Cyclic Group to re set to the first field in the list. Any one got an idea or how this can be done without them scrolling through the groups.

Re: Cyclic Group

m_woolf — Thu, 05 Mar 2015 17:31:42 GMT

This can be done with a macro.

sub set_group_field

set gp = ActiveDocument.GetGroup("GroupName")

do while gp.GetActiveField.Name <> "FieldName"

gp.Cycle 1

loop

end sub

Re: Cyclic Group

Fri, 06 Mar 2015 09:06:39 GMT

Thanks Mike

I did mention the Macro but they seem determined not to use Macro's on any of there projects. Do you know of any other way.