topic Can I access a variable's predefined list through a macro? in QlikView

Can I access a variable's predefined list through a macro?

Fri, 04 Mar 2011 20:40:01 GMT

Greetings.

I have variables with predefined lists. I would like to use that list in a macro, and I have no idea how to access it. I can see PreDefinedList as a property, and there is an example on how to set it, but I have no idea how to pull the data from it.

Help?

Thanks.

Can I access a variable's predefined list through a macro?

Fri, 04 Mar 2011 23:47:42 GMT

Hi,

try something like this:

set v = ActiveDocument.Variables("Variable1")

prop = v.GetProperties

dim list2

list2 = prop.PreDefinedList

msgbox(list2(0))

Regards!

Can I access a variable's predefined list through a macro?

Mon, 07 Mar 2011 16:25:59 GMT

My vb is terrible - I knew I was missing something straightforward.. That's exactly what I needed! Thanks.