Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

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
Partner
Partner

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",

Partner
Partner

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';

Highlighted
Partner
Partner

Re: QVD - QLIK SENSE DATA

Hi  Jonathan,

 could you calibrate your example on my data ? I thank you in advance
Partner
Partner

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;