import variables from another document

ali_hijazi — Tue, 17 Jan 2012 15:29:41 GMT

Hello

Attached is a macro that exports variables and their values or expressions to a text file

Is there a way to import these variables and their expressions to a new qvw document?

Please advise

import variables from another document

fosuzuki — Tue, 24 Jan 2012 00:57:48 GMT

Hi,

1. adjust your macro from:

txsStream.WriteLine v.Name & chr(9) & v.RawValue

to:

txsStream.WriteLine "set " & v.Name & " = '" & v.RawValue & "';"

2. copy the content of the generated text file to the script section of your new QVW

3. reload the document

There you go, the variables will be created in your new document. Maybe you'll need to do some adjustments if your variables have complex expressions with single and double quotation marks, this can confuse QV when you put it in the script.

(it is quite simple, I hope I understood right your requirement.... )

Regards,

Fernando

topic import variables from another document in QlikView

import variables from another document

import variables from another document