Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
aadilmadarveet
Valued Contributor

add all values from a particular field to a drill down group

Hi All.

Can anybody help me with this problem here...

Please let me know if there is a way to add all values to a drill down group from the field.

I am trying to find a way where a macro can run and read all the values from a field and add it to the group.

Thanks,
Aadil

1 Reply
sbaldwin
Contributor III

Re: add all values from a particular field to a drill down group

hi if you kept the field names in a column called META for example you could use this code to create the group STEVE:

sub createg
'activedocument.removegroup("STEVE")
activedocument.creategroup("STEVE")

Set val=ActiveDocument.Fields("META").GetPossibleValues(20000)
For i=0 to val.Count-1

activedocument.getgroup("STEVE").addfield(val.Item(i).Text)
next

end sub

Thanks

Steve

Community Browser