Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
jagannalla
Partner - Specialist III
Partner - Specialist III

How can i create qvd files?

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

26 Replies
matt_crowther
Luminary Alumni
Luminary Alumni

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

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
Partner - Specialist III
Partner - Specialist III
Author

How can save the file after clicking the button.

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

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

Not applicable

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
Luminary Alumni
Luminary Alumni

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
Partner - Specialist III
Partner - Specialist III
Author

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.

Not applicable

Hi,

Check this.

sub test

set obj = ActiveDocument.GetSheetObject("CH395")

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

end sub

- Sridhar



jagannalla
Partner - Specialist III
Partner - Specialist III
Author

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