Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Highlighted
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???