topic Re: Store Direct Discovery Data in QVD in QlikView

Store Direct Discovery Data in QVD

Anonymous — Sun, 19 Apr 2015 16:38:52 GMT

Hello Friends,

Is it possible to store Direct Discovery Data in QVD .

Re: Store Direct Discovery Data in QVD

Anonymous — Sun, 19 Apr 2015 17:14:37 GMT

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.

Re: Store Direct Discovery Data in QVD

mukesh24 — Mon, 20 Apr 2015 06:08:38 GMT

Hi Nitish,

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

Regards,

Mukesh

Re: Store Direct Discovery Data in QVD

jagan — Mon, 20 Apr 2015 06:21:57 GMT

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

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

Hope this helps you.

Regards,

Jagan.

Re: Store Direct Discovery Data in QVD

Anonymous — Mon, 20 Apr 2015 11:32:07 GMT

Jagan,

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

Regards,

Michael

Re: Store Direct Discovery Data in QVD

jagan — Tue, 21 Apr 2015 02:37:34 GMT

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.

Re: Store Direct Discovery Data in QVD

Anonymous — Tue, 21 Apr 2015 11:55:19 GMT

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