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

[rwunderlich]

If using the IE plugin, yo uhave the full range of export options available from right-click. If using AjaxZFC, the right-click Export only exports to csv. If you want to export to QVD from Ajax, you'll have to resort to using a macro attached to the button.

-Rob

[jagannalla]

Thanks Rob...

Can you clear me once again on this point.

"If you want to export to QVD from Ajax, you'll have to resort to using a macro attached to the button"

I didn't get what your saying.

[rwunderlich]

Create a macro to do the export as shown earlier in this thread. Then create a button. In the button action properties, use the run macro action and name the macro you created.

Rob

[jagannalla]

If it works at access point?

[suniljain]

you can use following macro.

set obj = ActiveDocument.GetSheetObject("CH01")

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

[jagannalla]

Sunil,

ya you are right.. But i want to know whether this code works at access point. If it works which path we need to give at access point.

[andreas_koehler]

Hi !

I guess that this was changed since 2011. For people like me who come here some years later and struggle as they can not export to xls or xlsx using Qlikview 12.00:

What worked for me:    

               obj.ExportEx "C:\Temp\test.xls", 5

It would be great if someone can add how to export to xlsx.