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

       

        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?