topic Export to txt with variable location in QlikView

Export to txt with variable location

w_heres — Thu, 16 Dec 2010 17:57:40 GMT

Hi,

I want to make an export of a table to a .txt file. The location for the exportfile need to be variable.

In VBScript I've the following code:



SUB TestExport
' The QlikView object
Set obj = ActiveDocument.GetSheetObject("ExportTXT")
 ' The variable for the export location of the file
set v = ActiveDocument.Variables("vLocationTXT")

set loc = v & "\Exportfiles"&" "&day(now())&"-"&month(now())&"-"&year(now())&"_"& hour(now()) &"-"& minute(now())&"-"& second(now())& ".txt"
END SUB

But this didn't work. Does anyone have a solution for this?

Thanks in advance,

Wiegert

Export to txt with variable location

Anonymous — Thu, 16 Dec 2010 20:25:25 GMT

Wiegert,

First, it should be
set loc = v.GetContent.string & ...
Next, the export itself:
obj.Export loc
(I'm not sure about the exact syntax of the last one, give it a try...)

Export to txt with variable location

w_heres — Fri, 17 Dec 2010 10:29:35 GMT

Hi Michael,

thanks for your reply. The following code works:


SUB TestExport
' The QlikView object
Set obj = ActiveDocument.GetSheetObject("ExportTXT")
 ' The variable for the export location of the file
set v = ActiveDocument.Variables("vLocationTXT")
loc = v & "\Exportfiles"&" "&day(now())&"-"&month(now())&"-"&year(now())&"_"& hour(now()) &"-"& minute(now())&"-"& second(now())& ".txt"obj.Export loc , "="
END SUB

Thanks,

Wiegert