topic Retrieving values from associated field in QlikView

Retrieving values from associated field

Wed, 22 Apr 2009 22:42:12 GMT

That seemed to fix the problem. One last question. When you select something the item turns green and other selection boxes show ,in white, matches (but is not green). I am using "ActiveDocument.Fields("field").GetMemberValue(2)" to retrive the value in a field but it only works if the field is "green" (selected). Can values be retrieve from a field where the items are "white" ( ie not actually selected and thus not green)?

Retrieving values from associated field

Wed, 22 Apr 2009 23:00:54 GMT

It sounds like this is a continuation of another discussion. If I'm jumping in, then I apologize.

I think you need to use GetPossibleValues instead of GetMemberValue to get the white values. In the API Guide, they use a loop to pick every possible value for a specific field.

Retrieving values from associated field

Wed, 22 Apr 2009 23:08:24 GMT

Sorry you are right I didn't mean to create a new post. Anyway, GetPossibleValues worked for what I need.

Thanks for your help NMiller. Other then some clean up and error trapping all is working.

Retrieving values from associated field

Wed, 22 Apr 2009 23:10:48 GMT

Glad to help and I promise I'm not following you around the forum.