topic Re: Count total groups in document in QlikView

Count total groups in document

Anonymous — Fri, 17 Apr 2015 12:34:41 GMT

Hi,

I see this sample in API Guide:

groups = ActiveDocument.GetGroups

set gp = groups(0).GetProperties

vars = gp.Labels

msgbox vars(0)

I want to know the total of groups in a document to do a loop. I'm trying something like this:

groups = ActiveDocument.GetGroups

total = groups.Count

For i=0 to total-1

Set gp = groups(i).GetProperties

...

But I don't how I can get the number of total groups in a QlikView document. I tried searching on API Guide but I didn't found anything.

Can anybody help me or know how I

Re: Count total groups in document

jpenuliar — Fri, 17 Apr 2015 12:39:31 GMT

You can use Rob Wunderlich's Document Analyzer

Re: Count total groups in document

sunny_talwar — Fri, 17 Apr 2015 12:41:35 GMT

You can download the analyzer from here http://qlikviewcookbook.com/recipes/download-info/document-analyzer/

Best,

Sunny

Re: Count total groups in document

jpenuliar — Fri, 17 Apr 2015 12:45:58 GMT

here's one I found:

Macro: Loop over all groups?

Re: Count total groups in document

Anonymous — Mon, 20 Apr 2015 12:42:01 GMT

Thanks sunindia! I check the analyzer and the following code works for me!

rem *** Extract groups from a Document object

Sub extractGroups(docObj)

'Dim groups, gp, i, j, fields, field, groupName

log "Extracting Groups"

groups = docObj.GetGroups

for i = lbound(groups) to ubound(groups)

set gp = groups(i).GetProperties

groupName = gp.Name

If gp.IsCyclic Then groupType = "Cyclic" Else groupType = "Drill"

set fields = gp.FieldDefs

for j = 0 to fields.Count-1

set fld = fields(j)

groupsFile.WriteLine( _

csvQuote(groupName) _

& "," & csvQuote(groupType) _

& "," & csvQuote(fld.Name) _

)

End Sub

Re: Count total groups in document

sunny_talwar — Mon, 20 Apr 2015 12:44:26 GMT

I am glad it worked, but I think you should thank JPenuliar because he gave you the idea to use that, I just gave you the link to the place from where you can download it

Best,

Sunny

Re: Count total groups in document

Anonymous — Mon, 20 Apr 2015 12:45:41 GMT

Thanks for your help Jonathan! It works for me!

Re: Count total groups in document

jpenuliar — Mon, 20 Apr 2015 12:56:02 GMT

No Worries Daniel, and Thanks to the points you awarded, I am now a Wizard.

Re: Count total groups in document

sunny_talwar — Mon, 20 Apr 2015 12:57:27 GMT

Yay!! Congratulations Jonathan Penuliar

Best,

Sunny

Re: Count total groups in document

jpenuliar — Mon, 20 Apr 2015 12:58:41 GMT

Thank you sunindia‌