How can i create qvd files?

[jagannalla]

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

[matt_crowther]

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

[suniljain]

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.

[jagannalla]

How can save the file after clicking the button.

[jagannalla]

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

[#6]

Hi

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

[matt_crowther]

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

[jagannalla]

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.

[#9]

Hi,

Check this.

sub test

set obj = ActiveDocument.GetSheetObject("CH395")

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

end sub

- Sridhar

[jagannalla]

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........