topic Re: Changing a QlikView variable value through macro in QlikView

Changing a QlikView variable value through macro

Mon, 17 Feb 2014 11:23:21 GMT

Hi,

I have the following issue:

1. I have a QlikView Variable named "vRunMacro" with a value "false".

2. I have a macro that runs on opening the QVW file.

3. the macro has functions that run if vRunMacro=true. so, when a normal user open the file the functions don't run.

4. I run a batch file that opens the QVW and sends to vRunMacro the value "true".

5. everything runs perfetly.

now, I want to change the vRunMacro back to the value of "false",

can you please help?

I tried in many ways and could not see a change in variable overview when I look after the macro was performed...

Thanks!

marcus_sommer — Mon, 17 Feb 2014 11:32:16 GMT

Try this:

ActiveDocument.Variables("vRunMacro").SetContent "false", true

- Marcus

Mon, 17 Feb 2014 12:27:02 GMT

I know, it should be that simple, right?

I added this line to my macro and it did not change the value...any advice?

marcus_sommer — Mon, 17 Feb 2014 12:43:52 GMT

Are you run your macro/batch from outside then you must also save your qvw.

- Marcus

Mon, 17 Feb 2014 14:48:50 GMT

thanks, this seems to be working thank you!