field as array of existing values

Wed, 28 Mar 2012 07:17:04 GMT

hi there

I've been trying to creat Arrays of values existing in specific fields.

for example:

set arr1 = ActiveDocument.GetField("X").GetPossibleValues

However, the "IArrayOfFieldValue" Object returned is always a 'DISTINCT' one, for instance, if may table look like this:

M X

b 10

g 10

s 12

now arr1 has 2 values, arr1.item(0) = 10 and arr1.Item(1) = 12.

my need is to hold all possible values..

could really use some help with this..

thanks

topic field as array of existing values in QlikView