topic Create QVD by macro and buffer prefix in QlikView

Create QVD by macro and buffer prefix

Tue, 24 Jun 2014 06:31:55 GMT

Hello everyone ..

I want to create a qvd file for my sheet object like for a calculated table object and a bar chart.

I created a macro

sub CreateQvd

set obj = ActiveDocument.GetSheetObject("CH01")

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

end sub

and added a action to OnPostReload Trigger to run this macro.. But there is no qvd file generate for that table chart.

Did I make any mistake,if anyone has any idea please share,it will very helpful.

And one more thing how to create qvd automatic by Buffer Prefix.

Because I wrote a script

Buffer Load * from Emp.xls;

but it wont create any qvd file. Please make this clear to me.

Thank you in advance..

Re: Create QVD by macro and buffer prefix

ashfaq_haseeb — Tue, 24 Jun 2014 06:50:30 GMT

Hi,

Look at the below post.

http://community.qlik.com/docs/DOC-5661

Regards

ASHFAQ

Re: Create QVD by macro and buffer prefix

ashfaq_haseeb — Tue, 24 Jun 2014 07:01:42 GMT

Hi,

Look at the attache application even.

Regards

ASHFAQ

Re: Create QVD by macro and buffer prefix

Sat, 01 Aug 2015 01:14:39 GMT

if u impose Buffer load it will create the QVD automatically in specific path...u should check ur default path......go to settings>user preferences>locations>QVD path

Re: Create QVD by macro and buffer prefix

Mon, 15 Feb 2016 16:31:28 GMT

Hi,

Let vRutaDoc = 'C:\';

You can to use this:

ExcelDatos:

Buffer Load * from Emp.xls

Store * from ExcelDatos into $(vRutaDoc)abc.qvd;

I hope it help you.