topic Re: How to Export variables declare in variable overview in QlikView

How to Export variables declare in variable overview

Mon, 26 Apr 2010 10:23:33 GMT

Hai,

I want to use the variables that already declared in variable overview of an Application.

Is it possible to Export the variable.

and how to use same variable for an new application. Can anyone let me know.Its very useful for me.

Regard,

Vijay

How to Export variables declare in variable overview

Mon, 26 Apr 2010 12:08:35 GMT

I don't know of a way to export your current variables, however, the way I set up QlikView to allow re-using variables is that I define them all in a QVS file and then include the file in the load script. I have attached a copy of a QVS file to this message (please note: I had to rename it to .QVS.TXT to get it to attach) so you can take a look, in the load script you would simply add in a line like this:

$(Include = "\QlikView\QVS\StandardVariables.QVS")

Good luck,

How to Export variables declare in variable overview

Tue, 27 Apr 2010 05:17:18 GMT

Hai,

Thanks for your reply.

If i declare the variable in Edit script it is easy to export it into QVS file and use that in other application.

But i need an way to export the variable that declare in variable overview. if you find any solution please let me know. its very useful.

Thanks

Regards

Vijay

How to Export variables declare in variable overview

Tue, 27 Apr 2010 10:03:58 GMT

Hi,

This little macro will export all the names of the document variables to a .txt file. The file location should be defined in the variable vExportTo. It would be quite easy to also export the variable values too. Remember to change the module security too to allow access to the system.

sub ExportVarNames

set doc = ActiveDocument

vExportTo = doc.Variables("vExportTo").GetContent.String

set fso = CreateObject("Scripting.FileSystemObject")

on error resume next

set logFile = fso.GetFile(vExportTo)

if err <> 0 then ' file does not exist
on error goto 0
set logFile = fso.CreateTextFile(vExportTo)
set logFile = fso.GetFile(vExportTo)
else
on error goto 0
end if

set txsStream = logFile.OpenAsTextStream(8) ' append

set vars = ActiveDocument.GetVariableDescriptions

for i = 0 to vars.Count - 1
set v = vars.Item(i)
txsStream.WriteLine v.Name
next

txsStream.Close

end sub

Regards,

Gordon

How to Export variables declare in variable overview

jagannalla — Mon, 23 May 2011 06:33:10 GMT

Hi Gordon,

I'm also trying to do same as vijayakumar. You written a macro to export all the variables into text file it is working fine. But how can i use this variables in another qlikview file along with data of the variables.

- I can see only variables name in the text file but there is no data for particular variables. I declared variable vExportTo='C:\Jagan\QVExamples\RTQ\RTQ\aa.txt

Is it correct? If correct how can i overcome this problem?

How to Export variables declare in variable overview

Tue, 21 Jun 2011 07:47:45 GMT

change your for-next loop to:

for i = 0 to vars.Count - 1

set v = vars.Item(i)

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

this will create a tab-separated list for var names and values.

Re: How to Export variables declare in variable overview

xtrimf — Sun, 04 Dec 2011 12:16:29 GMT

Hi,

It is not working for me..

I get error "Object required: 'doc.Variables(...)'"....

Re: How to Export variables declare in variable overview

Sun, 04 Dec 2011 15:41:18 GMT

Make sure you have the variable defined that holds the path to your export location. In this case, define vExportTo in your app. (Ctrl-V is the shortcut to the variable list)

Re: How to Export variables declare in variable overview

xtrimf — Sun, 04 Dec 2011 17:03:05 GMT

Tnx

it work now perfectly!

How to Export variables declare in variable overview

Mon, 12 Dec 2011 10:52:06 GMT

I'm using AxQlikOCX to export all variables with name and value. This is my code:

Doc = AxQlikOCX.Application.OpenDocEx([Path to QVW-document], 1, False, , , , True)

Dim vars

Dim v

vars = Doc.GetVariableDescriptions

For i As Integer = 0 To vars.count - 1

v = vars.item(i)

debug.print v.Name & " = " & v.RawValue

Next

I get the name but value is empty!

Any ideas?

How to Export variables declare in variable overview

Mon, 12 Dec 2011 11:00:54 GMT

Ok Guys... the parameter "no data" was TRUE... D'oh!

Re: How to Export variables declare in variable overview

gshockxcc — Thu, 25 Jun 2015 21:02:58 GMT

Hi Tammy,

I am getting "Permission Denied" when running this macro at the following line:

set logFile = fso.CreateTextFile(vExportTo)

I have Module and Local security set to System Access and Allow System Access, respectively.

Not sure why it's not working. Any ideas?

Thanks,

Re: How to Export variables declare in variable overview

Thu, 25 Jun 2015 22:17:39 GMT

hi-

perhaps it's a file-system permissions issue? does your id have permission

to write to the location in vExportTo ?

On Thu, Jun 25, 2015 at 5:03 PM, Kristan Sears <qcwebmaster@qlikview.com>

Re: How to Export variables declare in variable overview

gshockxcc — Fri, 26 Jun 2015 13:07:48 GMT

I do have permissions to that file location. I tried on two different computers and had the same result.

Re: How to Export variables declare in variable overview

gshockxcc — Fri, 26 Jun 2015 13:12:19 GMT

Does the file export path need to be the same as the path where the Qlikview file resides?

Re: How to Export variables declare in variable overview

gshockxcc — Fri, 26 Jun 2015 14:51:55 GMT

User error: needed to specify the file name in the Variable Overview. Works great! Thank you.