Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

QVD Generator doesn't work

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

1 Solution

Accepted Solutions
MVP
MVP

Re: QVD Generator doesn't work

Can you check if the path is an issue. Your excel file is loaded from qlikview_applications$ where as variable is storing it to qlikview_application (without a dollar sign)Capture.PNG

I would thing that the two would match up?

2 Replies
MVP
MVP

Re: QVD Generator doesn't work

Can you check if the path is an issue. Your excel file is loaded from qlikview_applications$ where as variable is storing it to qlikview_application (without a dollar sign)Capture.PNG

I would thing that the two would match up?

Not applicable

Re: QVD Generator doesn't work

Indeed it works with the '$', Thank you !

Community Browser