topic Creating Group through Macro in QlikView

Creating Group through Macro

bharatkishore — Wed, 28 Dec 2011 06:25:25 GMT

Hello All,

I have generated a group with 4 fields like A,B,C,D.Now i want to create another group with same fields by using Macro function.Can any one help me how to do this.

I am attaching my qlikview file for ur better understanding.

Creating Group through Macro

forte — Wed, 28 Dec 2011 07:48:47 GMT

Hi bharatkishore,

I think this macro example can be usefull,

sub copyGroup

Set gr = ActiveDocument.CreateGroup("GROUP2")

set gd = ActiveDocument.GetGroupDescription("GROUP1")

'Firstly we copy iscyclic property
gp = gr.GetProperties
gp.IsCyclic = gd.IsCyclic
gr.SetProperties gp

'Just add each field on GROUP1 TO GROUP2
set fdefs = gd.FieldDefs

for i = 0 to fdefs.Count-1

set fld = fdefs.Item(i)
gr.AddField fld.Name

end sub

Regars

Creating Group through Macro

bharatkishore — Wed, 28 Dec 2011 08:04:01 GMT

Thanks Forte.