topic Re: Use macro to bring a specific variable from another qvw in QlikView

Use macro to bring a specific variable from another qvw

Anonymous — Tue, 10 Sep 2013 16:04:59 GMT

Hi,

I'm trying to set a variable with the active sheet of a qvw using a macro:

sub ActiveSheet

set v = ActiveDocument.Variables("vTest")

set s = ActiveDocument.ActiveSheet

v.SetContent s.GetProperties.SheetId,true

end sub

Now I want to read this vTest at the opening of another qvw and save it with the same name vTest.

How can I do this???

Gysbert_Wassenaar — Tue, 10 Sep 2013 16:23:35 GMT

Maybe something like this:

Sub SetvTest

set QVar = ActiveDocument.Variables("vTest")

set QApp = CreateObject("QlikTech.QlikView")

set QDoc = QApp.OpenDoc "C:\MyOtherDoc.qvw"

QVar.SetContent QDoc.Variables("vTest").GetContent.String

QDoc.Close

QApp.Quit

set QVar = nothing

set QDoc = nothing

set QApp = nothing

End Sub

Anonymous — Tue, 10 Sep 2013 19:39:31 GMT

is there any way to do it without the OpenDoc?