topic Changing value of variable in QlikView

Changing value of variable

Thu, 14 Jan 2010 13:59:10 GMT

I wonder if someone can help.

I set up a variable in script: LET vZoom=0;

I'm trying to create a button that will toggle the value of the variable between 0 and 1 every time I press it by running the following macro:

SUB Zoom_Toggle()
Select Case vZoom
Case 1
vTest=0
Case 0
vTest=1
End Select
ActiveDocument.Variables("vZoom").SetContent vTest, true
END SUB

However, the button only seems to change the value the first time I press it and stops working.

Am I missing something?

Thanks for helping

Changing value of variable

Thu, 14 Jan 2010 15:59:47 GMT

You're not referencing the variable correctly in your Case.

SUB Zoom_Toggle()
 Select Case ActiveDocument.Variables("vZoom").GetContent.Number
 Case 1
 vTest=0
 Case 0
 vTest=1
 End Select
 ActiveDocument.Variables("vZoom").SetContent vTest, true
END SUB

I think it is .Number there.

Changing value of variable

Thu, 14 Jan 2010 17:12:55 GMT

Excellent. .Number didn't work but I found that .String did and now the button works perfectly.

Cheers!