topic Re: Not creating qvd file in QlikView

Not creating qvd file

jagannalla — Wed, 27 Jul 2011 13:02:50 GMT

Hi,

In my qvw file i written OnOpen action to reload my file with macro code. Now it's reloading the file. And I also written on OnPostReload to create qvd file for table box.

- But it is not working for me. i.e it is not generating qvd file for me.

Can anyone help me

Not creating qvd file

rahulgupta — Wed, 27 Jul 2011 14:35:17 GMT

Hi,

Can you please attach any sample file.

Regards

Re: Not creating qvd file

jagannalla — Wed, 27 Jul 2011 15:10:35 GMT

Hi Rahul,

I'm attaching sample qvw file for your reference.

Re: Not creating qvd file

rahulgupta — Wed, 27 Jul 2011 15:30:10 GMT

Hey Hi,

You can use this way.

Regards

Re: Not creating qvd file

daveamz — Wed, 27 Jul 2011 15:33:04 GMT

Hi Mr. Nokia,

Try to export the file to other driver than C:\

I got the "Cannot open file C:\Test.qvd for writing!" message. After I've set target to D:\ (obj.Export "D:\Test.qvd",",") it worked.

Regards!

Not creating qvd file

kaushiknsolanki — Thu, 28 Jul 2011 06:19:00 GMT

Hi,

The code you have written is working at my side.

Can you please tell us what is the error that you are getting.

Regards,

Kaushik Solanki

Not creating qvd file

ToniKautto — Thu, 28 Jul 2011 08:45:33 GMT

ActiveDocument.Export creates a SKV file, which is a semicolon separated textfile.

According to QlikView API Guide the QVD can be generated by using ExportEx with Export Format set to 4 as example below shows.

set obj = ActiveDocument.GetSheetObject("CH01")

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

Re: Not creating qvd file

jagannalla — Thu, 28 Jul 2011 09:33:56 GMT

I think you are reloading manually. Don't do that create a macro code to reload and apply OnOpen trigger. Now just close the qvw file and open now it should create qvd file. But it is not creating qvd file.

- I tried like this i had created a batch file to reload this qvw file. Then it is creating qvd file when batch file is running.

Not creating qvd file

ToniKautto — Wed, 03 Aug 2011 09:59:04 GMT

Ah, did not realize that you have a Table box in the example. You need to select the export function carefully, depending on how you plan to execute it. And then of course there need to be write access to the folder where file is written.

Export Straight table chart to QVD;

set obj = ActiveDocument.GetSheetObject("CH01")

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

Export Table Box object on ServerSide to QVD;

set obj = ActiveDocument.GetSheetObject("TB01")

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