how to make qvd in qliksense

[Anonymous]

How to make qvd in qliksense?

[#2]

The same way you would in QlikView, i.e. in the script (dataload editor in Qlik Sense) after a load statement:

store <tablename> into <qvd name>.qvd (qvd);

[Anonymous]

But its not working in Mine.

I have written the following script;:

Test:

LOAD

    Name,

    "Date"

FROM [lib://R&D/Test.qvd]

(qvd);

store Test into D:\Test1.qvd;

[Anonymous]

Hi Erika

You will need to use the "lib" syntax to save the qvd. So in your case something like:

STORE Test into [lib://R&D/Test1.qvd];

If you want to use path names eg d:\test\ then you will need to enable "Legacy Mode".

See the help page here if you wish to do this.

[its_anandrjs]

Hi,

Your syntax for QVD creation is correct that is

store Test into D:\Test1.qvd;

What error you get can you elaborate or paste error snap here.

Regards

Anand

[Michael_Tarallo · Accepted solution]

Hi  Erika,

The suggestion that Tim has provided is the correct step with the default settings in Qlik Sense.

You must use the LIB syntax instead of the drive letter.

You must have a folder connection created with a name that you will also reference in the LIB statement:

Here is the correct syntax that should work for you - with a sample table:

ASCII:

Load

if(RecNo()>=65 and RecNo()<=90,RecNo()-64) as Num,

Chr(RecNo()) as AsciiAlpha,

RecNo() as AsciiNum

autogenerate 255

Where (RecNo()>=32 and RecNo()<=126) or RecNo()>=160 ;

STORE ASCII into [lib://myFolder/Test1.qvd];

Note: If you want to use the drive letter the way you would using QlikView- you must Disable Standard Mode (Qlik Sense Desktop)

You can read up on that here:

Hope this helps.

These videos might also help you: New to Qlik Sense Videos

Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik