topic Cycle a Group that contains an expression in QlikView

Cycle a Group that contains an expression

joefeyas — Tue, 21 Jun 2011 18:15:35 GMT

I've been using some vb code similar to below to cycle through my cycle group, however after adding an expression it now blows up on the GetActvieField.Name.

Does anyone know a suggested work around?

sub set_group_field
set gp = ActiveDocument.GetGroup("GroupName")
do while gp.GetActiveField.Name <> "FieldName"
gp.Cycle 1
loop
end sub

Cycle a Group that contains an expression

erichshiino — Tue, 21 Jun 2011 18:22:39 GMT

I guess it`s returning the expression definition instead of the name you gave to it.

You can use some msgbox( gp.GetActiveField.Name) to check what is going on...

I suggest you create another field on the script if it is possible

Hope this helps,

Erich

Re: Cycle a Group that contains an expression

joefeyas — Tue, 21 Jun 2011 21:32:47 GMT

Erich - I tired that but unfortunately the error is being thrown on the gp.Activefield.Name reference.

Re: Cycle a Group that contains an expression

erichshiino — Wed, 22 Jun 2011 01:48:35 GMT

Ok,

I tried different macros...

this expression should work for you:

do while activedocument.evaluate("=GetCurrentField([GroupName])") <> "FIELDNAME"

You can check the possible results with:

msgbox ( activedocument.evaluate("=GetCurrentField([GroupName])"))

The only difference will be that for a calculated dimension, the currentfield will return the whole expression...

Hope this helps this time

Regards,

Erich

Re: Cycle a Group that contains an expression

joefeyas — Wed, 22 Jun 2011 15:37:48 GMT

That worked perfectly, thanks so much.