topic Cycle Group in QlikView

Cycle Group

Mon, 17 May 2010 18:06:22 GMT

I want to create a dynamic Cycle group and set the Group as Cyclic .But I am not sure what I am missing in the below code.It throws me error at "gp.IsCyclic = true" .

Sub DymnamicGroup
ActiveDocument.RemoveGroup "Dimensions"
Set gr = ActiveDocument.CreateGroup("Dimensions")
gr.AddField "Age Range"
gr.AddField "Diagnosis Combo Desc"
gr.AddField "Diagnosis Desc"

set gp = ActiveDocument.GetGroup("Dimensions")
gp.IsCyclic = true

End Sub

Thanks

Priya

Cycle Group

spsrk_84 — Tue, 18 May 2010 06:25:46 GMT

Hi Priya,

I think what the macro u had written absolutely fine but i think the consition which u had given iscyclic =true i feel u would have given while creating the group itself, i am not sure check this one also

Sub DymnamicGroup
ActiveDocument.RemoveGroup "Dimensions"
Set gr = ActiveDocument.CreateGroup("Dimensions")
gr.AddField "Age Range"
gr.AddField "Diagnosis Combo Desc"
gr.AddField "Diagnosis Desc"

gr.IsCyclic = true

set gp = ActiveDocument.GetGroup("Dimensions")

Check like this ,meanwhile i will aslo try

Regards,

Ajay
End Sub

Cycle Group

Tue, 18 May 2010 18:59:12 GMT

Thank you Ajay

I will try and will let you know if it works.

Cycle Group

Tue, 18 May 2010 19:27:57 GMT

The below macro works.

Sub DymnamicGroup
ActiveDocument.RemoveGroup "Dimensions"
Set gr = ActiveDocument.CreateGroup("Dimensions")
gr.AddField "Age Range"
gr.AddField "Diagnosis Combo Desc"
gr.AddField "Diagnosis Desc"
gr.AddField "Payment Type"

set gp = ActiveDocument.GetGroup("Dimensions").GetProperties

gp.IsCyclic = true

ActiveDocument.GetGroup("Dimensions").SetProperties gp

ActiveDocument.GetApplication.Refresh

End Sub