2 Replies Latest reply: Jun 5, 2017 6:18 AM by ja ja RSS

    Qlikview - append data to Excel

    ja ja

      Hi all,


      I have qvw file with sql query



        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?