Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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?

View solution in original post

2 Replies
sunny_talwar

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
Author

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