Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Store Direct Discovery Data in QVD

Hello Friends,

Is it possible to store Direct Discovery Data in QVD .

6 Replies
Anonymous
Not applicable
Author

The closest to you request I can think of is to export a front end object (if it is a table) into a QVD file.

mukesh24
Partner - Creator III
Partner - Creator III

Hi Nitish,

It is poosible through front end objects(Straight, Pivot Table,...)

Regards,

Mukesh

jagan
Luminary Alumni
Luminary Alumni

Hi,

It is not possible like we do in scripting, since it fetches the data dynamically so we have to export the data from Table objects to and save it as Excel or CSV, or you can write macro to store data to QVD

  1. sub ChartToQVD 
  2.     set obj = ActiveDocument.GetSheetObject("CH01"
  3.     obj.ExportEx "QvdName.qvd", 4 
  4. end sub 

Hope this helps you.

Regards,

Jagan.

Anonymous
Not applicable
Author

Jagan,

Macro is fine but not necessary - you can export a table to QVD the same way as to, for example, CSV.

Regards,

Michael

jagan
Luminary Alumni
Luminary Alumni

Hi Micheal,

I am not aware of this, please let me know how to export a table to QVD.  Macro is used to export to QVD on click of a button or post reload of a document.  It is an automated one, no need of manual creation.

Regards,

Jagan.

Anonymous
Not applicable
Author

Hi Jagan,

There is nothing wrong with your macro, except - it is a macro

I meant manual export, that is right click on a front-end table, chose "Export...", and in "Save as type" - choose "qvd", it is on the very bottom.  Available only for the table objects.

Regards,

Michael