Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Ok thanks,
can you give me some example please???