Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
mihai_iov
Contributor II

Export variable to Excel

I have a variable called "vAvgPerCountry" that I need to export into Excel using a macro(because I also have other tables to export).
I understand that ActiveDocument.Variables("vAvgPerCountry").GetContent.Var can be used to get the value of the variable, but how do you paste it in Excel?

4 Replies
devarasu07
Honored Contributor II

Re: Export variable to Excel

sasikanth
Valued Contributor III

Re: Export variable to Excel

hi,

you can use input box to export a variable to excel,

mihai_iov
Contributor II

Re: Export variable to Excel

The .qvw file is no longer available for download

devarasu07
Honored Contributor II

Re: Export variable to Excel

Hi,

able to downloaded from Rob blog and it's working. FYI refer to the attachment. Tks