Qlikview - append data to Excel

[Anonymous]

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?

[jyothish8807]

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

[Anonymous]

Ok thanks,

can you give me some example please???