Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

QVD - QLIK SENSE DATA

Hi Community,

I'm not able to store data into file .qvd

Mezzi:

LOAD

  "ORTP_DESC",

  "MCAT_DESCR"

STORE Mezzi INTO C:\MEZZI.qvd;

SQL SELECT

"ORTP_DESC",

"ORTP_DESC"

FROM NameDatabase.dbo.MEZZI;

but I receive an error message

Si è verificato il seguente errore:

Invalid Path

L'errore si è verificato qui:

Mezzi: LOAD "ORTP_DESC", "MCAT_DESCR",

5 Replies
fmazzarelli
Contributor III

Re: QVD - QLIK SENSE DATA

error...

Hi Community,

I'm not able to store data into file .qvd

Mezzi:

LOAD

  "ORTP_DESC",

  "MCAT_DESCR"

STORE Mezzi INTO C:\MEZZI.qvd;

SQL SELECT

"ORTP_DESC",

"MCAT_DESCR"

FROM NameDatabase.dbo.MEZZI;

but I receive an error message

Si è verificato il seguente errore:

Invalid Path

L'errore si è verificato qui:

Mezzi: LOAD "ORTP_DESC", "MCAT_DESCR",

fredericmante
New Contributor III

Re: QVD - QLIK SENSE DATA

try this

Mezzi:

LOAD

  "ORTP_DESC",

  "MCAT_DESCR";

SQL SELECT

"ORTP_DESC",

"ORTP_DESC"

FROM NameDatabase.dbo.MEZZI;

STORE Mezzi INTO C:\MEZZI.qvd;

regards

Employee
Employee

Re: QVD - QLIK SENSE DATA

The syntax is invalid for QlikView and Qlik Sense. The above syntax is valid for QlikView but not Sense (unless you reconfigure to run in legacy mode).

You need to create a database connection and reference that in the FROM for your SQL load.

You will also need to create a folder connection to define where the QVD is stored and , in the store command, reference the folder location:

Store * from mytable into 'lib://FolderConnection/myfile.qvd';

Store * from mytable into 'lib://FolderConnection/myfile.qvd';

Store Name as a, RegNo as b from mytable into 'lib://FolderConnection/myfile.qvd';

fmazzarelli
Contributor III

Re: QVD - QLIK SENSE DATA

Hi  Jonathan,

 could you calibrate your example on my data ? I thank you in advance
fmazzarelli
Contributor III

Re: QVD - QLIK SENSE DATA

Hi Jonathan,

i solved.

Mezzi:

LOAD

  "ORTP_DESC",

  "MCAT_DESCR";

SQL SELECT

"ORTP_DESC",

"ORTP_DESC"

FROM NameDatabase.dbo.MEZZI;

store MezziNew into [lib://ZONE/JAVA/MezziNew.qvd];

Drop Table MezziNew;

Community Browser