topic Re: Set Predefined Values in Drop-down with a macro? in QlikView

Set Predefined Values in Drop-down with a macro?

m_woolf — Mon, 06 Apr 2015 18:05:12 GMT

Is is possible to set the Predefined Values in Drop-down with a macro?

Re: Set Predefined Values in Drop-down with a macro?

Anonymous — Mon, 06 Apr 2015 19:43:59 GMT

Why would you want to do that?

Looks like you are already populating the values in your variable dynamically.

you creating a lot of variables on the fly and want to set the value list property for each them as 'predefined values in drop down' by writing a macro'?

Re: Set Predefined Values in Drop-down with a macro?

m_woolf — Mon, 06 Apr 2015 19:50:40 GMT

I am creating variables on the fly via a macro.

I have not been able to figure how to set the "Predefined Values in Drop-down" with the macro.

Maybe this can't be done, but I'm hoping for suggestions.

Re: Set Predefined Values in Drop-down with a macro?

Anonymous — Mon, 06 Apr 2015 20:06:43 GMT

Did you try creating one variable with required proeperties set in the fron-end (one time)

then read propeties (using getproperties method) from this variable and apply it to all the variables that you are creating in your macro (using setproperties method)

Re: Set Predefined Values in Drop-down with a macro?

m_woolf — Tue, 07 Apr 2015 12:11:00 GMT

Reading the properties from one variable and then trying to set the same properties to another variable cause VBScript to error with -2147467259.

Thanks for the suggestion.

Re: Set Predefined Values in Drop-down with a macro?

m_woolf — Tue, 07 Apr 2015 12:15:51 GMT

It worked after I added the middle line. Thanks again.

set prop = ActiveDocument.Variables("var1").GetProperties

prop.Name = "var2"

ActiveDocument.Variables("var2").SetProperties prop