QVD Generator doesn't work

Wed, 17 Feb 2016 13:03:18 GMT

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

Re: QVD Generator doesn't work

sunny_talwar — Thu, 18 Feb 2016 10:47:40 GMT

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)

I would thing that the two would match up?

Re: QVD Generator doesn't work

Thu, 18 Feb 2016 10:56:22 GMT

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

topic Re: QVD Generator doesn't work in QlikView

QVD Generator doesn't work

Re: QVD Generator doesn't work

Re: QVD Generator doesn't work