topic Macro Export and Import in QlikView

Macro Export and Import

Tue, 16 Mar 2010 15:41:34 GMT

Hi Everyone,

I'm trying to set up a macro button which will export the contents of a table with a lot of calculations out to a qvd, then pull that qvd back into QV to do some additional manipulations.

First, is this possible? Second, any adive or clues on what commands to use? I've read about how to create qvd's in the script, not sure how to do it in a macro.

Thank you,

Dave

Macro Export and Import

disqr_rm — Tue, 16 Mar 2010 15:48:21 GMT

Yes, very well possible.

You can export content of a chart (table) using macro:


set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportEx "C:\test.qvd", 4

After export you can trigger


ActiveDocument.PartialReload

to reload the document. Then in the QlikView script you can user REPLACE LOAD.... from this QVD file. REPLACE keyword will allow only this load to execute with partial reload. Before you do the load statement you can set ErrorMode varible to 0 and after load to 1 to ignore the error if no QVD exists.

Hope this gets you going.

Macro Export and Import

Wed, 17 Mar 2010 02:25:00 GMT

Thanks so much Rakesh! I used your tips and got my applications to work out exactly as I was intending.

Thanks again, Dave

Re: Macro Export and Import

stantrolav — Wed, 04 Dec 2013 11:01:47 GMT

Can i use any varible in name of exported file? SMTH like this:

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "$(varExportDir)\test_$(varReferenceDate).qvd", 4

Re: Macro Export and Import

Fri, 13 Mar 2015 02:53:38 GMT

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "C:\test.qvd", 4

What is use of 4?

Re: Macro Export and Import

dmohanty — Thu, 24 Sep 2015 14:38:19 GMT

Will this work in AJAX mode?

I can't get it work from Access Point in AJAX mode. Any alternatives to this please?