2 Replies Latest reply: Feb 18, 2016 5:56 AM by Sarah Antic RSS

    QVD Generator doesn't work

    Sarah Antic

      Hi Everyone,

       

      I'm trying to store data (froman excel file) into a qvd file and it does'nt work.

      Here's my script :

       

      Let vCheminQVD='\\Serv-qlikview\qlikview_applications\3_Data\ADM_GFI\QVD\PPI';

       

      PPI_Propective_M14:

      LOAD Catégorie,

           Signe,

           Section,

           Chapitre,

           [Détail Chapitre],

           Compte,

           [2013],

           [2014],

           [2015],

           [2016],

           [2017],

           [2018],

           [2019],

           [2020],

           [2021],

           [2022]

      FROM

      [\\Serv-qlikview\qlikview_applications$\3_Data\ADM_GFI\XLS\PPI_Qvw.xls]

      (biff, embedded labels, header is 1 lines, table is [Prospective QW BG $]);

      Store PPI_Propective_M14 into $(vCheminQVD)\PPI_Propective_M14.qvd (qvd);

      drop table PPI_Propective_M14;

       

       

       

       

      I can't figure out why it doesn't work. Any idea ?

       

       

      Thanks,

       

      Sarah