topic How can i create qvd files? in QlikView

How can i create qvd files?

jagannalla — Thu, 28 Apr 2011 11:07:03 GMT

Hi,

I want to create qvd files from front end. I'll explain briefly what i required.

- I know how to create qvd files from the edit script.

- In my report i have taken a table box or straight table i can generate the data into excel.

- Now, I'll take one button in the sheet when i click the button i want to create qvd file for particular table box or straight table data.

Is it possible to do it?

If possible how can i do this?

I need solution whether we can do or not. Plz help me if possible

How can i create qvd files?

matt_crowther — Thu, 28 Apr 2011 11:21:52 GMT

There may be a more elegant and simple solution than this but the following should work.

1. Create a button to export the TableBox / Straight Table to an Excel file in a static folder path.

2. Initiate a Partial Reload that loads in the newly created Excel file into a new QV Table.

3. In the Partial Load script export this new table to .qvd and then drop it to avoid conflicts with your data model.

Bit of a work around but it will work. You coould also have a completely seperate .qvw that simply converts the .xls files into .qvd's.

Hope that helps,

Matt - Visual Analytics Ltd

How can i create qvd files?

suniljain — Thu, 28 Apr 2011 11:32:54 GMT

Dear Boppy,

You can make QVD of the data display in your table box or straight table with the help of intermediate place only.

you have to save it into text file or csv or excel file and then you can make qvd of data from intermediate place.

How can i create qvd files?

jagannalla — Thu, 28 Apr 2011 11:57:59 GMT

How can save the file after clicking the button.

How can i create qvd files?

jagannalla — Thu, 28 Apr 2011 12:01:41 GMT

hi sunil,

please can you explain me clearly about what you said in your post

or can you provide step by step procuder to follow

Thnks

How can i create qvd files?

Thu, 28 Apr 2011 12:17:34 GMT

u can store the straight table data directly into qvd format.

the macro for storing qvd is

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

How can i create qvd files?

matt_crowther — Thu, 28 Apr 2011 12:29:05 GMT

Perfect solution - I knew I'd come across it before but couldn't find it in my API Guide.

Boppy; ignore my post the above solution is as good as it gets.

All the best,

Matt - Visual Analytics Ltd

How can i create qvd files?

jagannalla — Thu, 28 Apr 2011 12:46:31 GMT

I taken the button and tried like this..

Action --> run macro

In Edit module --->

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

But it is not working. I'm working on qlikview 10 version.

How can i create qvd files?

Thu, 28 Apr 2011 12:49:20 GMT

Hi,

Check this.

sub test

set obj = ActiveDocument.GetSheetObject("CH395")

obj.ExportBiff "C:\Test\test.qvd"

end sub

- Sridhar

How can i create qvd files?

jagannalla — Thu, 28 Apr 2011 12:54:16 GMT

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

When i click Test button in edit module . I'm getting the following error messge

Object doesn't support this property or method: 'obj.ExportEx'

- Y you take numeric 4 value there........

How can i create qvd files?

montubhardwaj — Thu, 28 Apr 2011 12:57:04 GMT

WoW.... that was perfect. We can store straight/pivot tables directly into qvds ....!!!

How can i create qvd files?

jagannalla — Thu, 28 Apr 2011 13:10:51 GMT

Thankq so much to share your knowledge with us...........

How can i create qvd files?

jagannalla — Thu, 28 Apr 2011 13:12:03 GMT

Thankq sridher it's working perfectly.....

How can i create qvd files?

jagannalla — Thu, 28 Apr 2011 13:14:18 GMT

How can i generate excel,pdf,text,delimeter files. For each i want to take button......

How can i create qvd files?

jagannalla — Thu, 28 Apr 2011 13:18:44 GMT

Thank you so much Gopinathan to help me.....

- I need one more thing.

I want to generate same thing to multiple tools like excel,pdf,text files. For each i want to keep different buttons.

How can i create qvd files?

rwunderlich — Thu, 28 Apr 2011 19:13:30 GMT

Forget the buttons and the macros. Just right click the object, select Export and you can choose the format you want, including qvd.

How can i create qvd files?

montubhardwaj — Thu, 28 Apr 2011 19:47:40 GMT

wow.....thats so simple.....thanks for sharing..... amazing....!!!!

How can i create qvd files?

jagannalla — Fri, 29 Apr 2011 13:26:23 GMT

This so simple but if it works in access point level.......

Re: How can i create qvd files?

Fri, 06 May 2011 12:17:16 GMT

u can add the codes within the same macro...

set obj = ActiveDocument.GetSheetObject("CH01")

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

the above script will store only straight or pivot tables into .qvd format.

it wont store the table box into .qvd format.

if you use the below script it will store delimiter format only, if you have doubt store one file and open the table in qlikview then u will see the format of loading, if you select qvd radio button the table will be empty.

set obj = ActiveDocument.GetSheetObject("CH395")

obj.ExportBiff "C:\Test\test.qvd"

if you want export to like excel,pdf,textfile write down the following things in your macro

set obj = ActiveDocument.GetSheetObject("CH01")

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

change the following numbers are add extra lines like

Set obj = ActiveDocument.GetSheetObject("CH01")

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

obj.ExportEx "C:\temp.xls", 6 for excel

4 qvd

3 xml

1 delimited

0 html

5 xml

6 xls

Re: How can i create qvd files?

jagannalla — Wed, 05 Oct 2011 16:05:47 GMT

Rob,

How can we create qvd at access point using button.

If we right click on object, select Export will work at access point.