topic Re: Export QVD into excel in QlikView

Export QVD into excel

warrentk80 — Tue, 30 Jul 2013 09:18:19 GMT

Good morning to all
I need to schedule and automate the export data to EXCEL some fields of a QVD file.
you can do this without macros?
in the Modify script after the Load event of the QVD files which commands should I enter?

thanks

Andrea

Re: Export QVD into excel

mikkeltaylor — Wed, 05 Feb 2014 08:34:34 GMT

Hi Andrea,

Did you ever get a solution to this?

If not I will be raising a similar post soon on the community, so keep an eye out for the answer.

Mike

Re: Export QVD into excel

nilesh_gangurde — Wed, 05 Feb 2014 08:40:30 GMT

At reload time you can store the QVD data into csv file.

like below mentioned script

Store Table_Name into FileName.csv(txt);

Hope this will help.

-Nilesh

Re: Export QVD into excel

giakoum — Wed, 05 Feb 2014 08:46:05 GMT

or use the post reload trigger and action export to save it to a text, delimited or tab delimited file. More options are available there than store.

Re: Export QVD into excel

Wed, 05 Feb 2014 10:08:03 GMT

Try to create a table box chart with the field that you want to export and then make a Send to Excel with a click.

Or try to create a button with an action for export n fields to a file (no excel). Look the image below...

Re: Export QVD into excel

mikkeltaylor — Tue, 11 Feb 2014 09:07:29 GMT

Perfect! thanks for all the replies. I just wasn't the original poster so unable to credit anyone