topic Re: How to get all values ? in QlikView

How to get all values ?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I use the following script to get all possible values in vb macro

SET Field1 = Doc.Fields("CodeGroupe").GetPossibleValues

How could I get all values possible and exluded for a field ?

marcus_sommer — Thu, 12 May 2016 14:11:42 GMT

I think the easiest way will be to create these list within a variable in the gui per:

vList:

= concat({1} distinct Total CodeGroupe, ',')

and query them within the macro:

SET Field1 = Doc.Variables("vList").GetContent.String

- Marcus

Anonymous — Thu, 12 May 2016 14:13:54 GMT

vList:

= concat({1} distinct Total CodeGroupe, ',')

and query them within the macro:

SET Field1 = Doc.Variables("vList").GetContent.String

Anonymous — Thu, 12 May 2016 14:51:46 GMT

how could I loop over each values in the list ?

swuehl — Thu, 12 May 2016 16:35:14 GMT

Or maybe something like

SUB Test

Set field = ActiveDocument.GetField("FieldName")

msgbox( field.GetCardinal )

for i = 1 to field.GetCardinal

msgbox(ActiveDocument.Evaluate("=FieldValue('FieldName',"&i&")"))

next

END SUB

marcus_sommer — Thu, 12 May 2016 17:36:40 GMT

You could create an array from this variable and loop through it, like:

...

arr = split(Field1, ",")

for i = 0 to ubound(arr) - 1

xyz = arr(i)

....

- Marcus

yakir_manor — Mon, 02 Oct 2017 14:27:13 GMT

did a small qvw with a simple macro that works