topic Macro Set Variable wont work in QlikView

Macro Set Variable wont work

Anonymous — Wed, 06 Aug 2014 08:12:37 GMT

Hi,

i want a click on a table to open another hidden sheet. Wrote the following macro:

ActiveDocument.Sheets("Qualität").Activate
set Q = ActiveDocument.Variables("vAdmin_Themensteuerung")

The first command works but it wont assing 'Q' to the variable.

What am i doing wrong?

sbaldwin — Wed, 06 Aug 2014 08:34:04 GMT

Hi are you missing the set bit ie:

Q.SetContent "Q", true

in the code above Q is the variable object in the script not the value.

Anonymous — Wed, 06 Aug 2014 08:43:56 GMT

Hi Steve,

added the line like this:

ActiveDocument.Sheets("Qualität").Activate
set Q = ActiveDocument.Variables("vAdmin_Themensteuerung")
Q.SetContent "Q", true

but it wont work either.

tresB — Wed, 06 Aug 2014 08:51:50 GMT

Try with only the bottom two lines. Does it work?

Anonymous — Wed, 06 Aug 2014 08:59:39 GMT

Hi tresesco,

yup, that works. I then switched the order to:

set v = ActiveDocument.Variables("vAdmin_Themensteuerung")
 v.SetContent "Q", true
 ActiveDocument.Sheets("Qualität").Activate

and that works too. Dont know why the order is critical but now it works. Thank You!