Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

try something like this:

set v = ActiveDocument.Variables("Variable1")

prop = v.GetProperties

dim list2

list2 = prop.PreDefinedList

msgbox(list2(0))



Regards!

View solution in original post

2 Replies
Not applicable
Author

Hi,

try something like this:

set v = ActiveDocument.Variables("Variable1")

prop = v.GetProperties

dim list2

list2 = prop.PreDefinedList

msgbox(list2(0))



Regards!

Not applicable
Author

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