Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
nitishvashisht
New Contributor

Store Direct Discovery Data in QVD

Hello Friends,

Is it possible to store Direct Discovery Data in QVD .

Tags (1)
6 Replies
mov
Esteemed Contributor III

Re: Store Direct Discovery Data in QVD

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
Contributor III

Re: Store Direct Discovery Data in QVD

Hi Nitish,

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

Regards,

Mukesh

MVP
MVP

Re: Store Direct Discovery Data in QVD

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.

mov
Esteemed Contributor III

Re: Store Direct Discovery Data in QVD

Jagan,

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

Regards,

Michael

MVP
MVP

Re: Store Direct Discovery Data in QVD

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.

mov
Esteemed Contributor III

Re: Store Direct Discovery Data in QVD

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

Community Browser