QVD - QLIK SENSE DATA

[fmazzarelli]

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

[fmazzarelli]

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]

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

[JonnyPoole]

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]

Hi  Jonathan,

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

[fmazzarelli]

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;