Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.
warrentk80
New Contributor III

Export QVD into excel

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

5 Replies
mikkeltaylor
Contributor II

Re: Export QVD into excel

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

nilesh_gangurde
Valued Contributor

Re: Export QVD into excel

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

giakoum
Honored Contributor II

Re: Export QVD into excel

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.

Not applicable

Re: Export QVD into excel

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...

screenshot.22.jpg

mikkeltaylor
Contributor II

Re: Export QVD into excel

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

Community Browser