Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
777proba777
New Contributor III

Qlikview - append data to Excel

Hi all,

I have qvw file with sql query

  Data:

  LOAD  source, color, date;

  select source, color, date

  as Mytable;

  STORE Data into  [..\QV_Data\Data.qvd] (qvd);


Then I export data to excel and save.

I need something to do that automatically instead of me

I need to run query every day and automatically send data to excel but keep old data in excel and append new value.

Can qlikview to do that?

Tags (2)
2 Replies
jyothish8807
Honored Contributor II

Re: Qlikview - append data to Excel

Hi Ja Ja,

This can be achieved by creating an on open trigger.

If you do not have a QMC then create a  .bat file to reload the qvw. A macro can be created to export the data in to excel.

Br,

Jyothish KC

Best Regards,
KC
777proba777
New Contributor III

Re: Qlikview - append data to Excel

Ok thanks,

can you give me some example please???