topic Re: Variables in Macro in QlikView

Variables in Macro

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I am trying to trigger a macro to change the value of a variable (v_sortIndex) and its not working.

You can see below how im doing:

Sub por

If v_sortIndex = 2 Then

v_sortIndex = 1

End if

Thanks in advance,

Filippo

m_woolf — Mon, 25 Jun 2018 14:12:58 GMT

This is from the API Guide:

set v = ActiveDocument.Variables("Variable1")

if not v.GetContent.IsNum then

msgbox(v.GetContent.String)

end if

set v = ActiveDocument.GetVariable("Variable1")

v.SetContent "123",true

Anonymous — Mon, 25 Jun 2018 14:52:44 GMT

What about the values (2, 3...)?

m_woolf — Mon, 25 Jun 2018 15:11:17 GMT

This can be done with a macro, but why not just use an action?

Anonymous — Mon, 25 Jun 2018 15:56:50 GMT

How? I want to that command to verify the value of a variable. If it's 2, then a i want to change to 1...

How can I do that if a action?

Thanks in advance

m_woolf — Mon, 25 Jun 2018 16:16:41 GMT

How does your variable gets it's value in the first place?