Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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

Highlighted
Employee
Employee

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

Hi  Jonathan,

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

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;