Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

erikajain02
New Contributor II

how to make qvd in qliksense

How to make qvd in qliksense?

1 Solution

Accepted Solutions
Employee
Employee

Re: how to make qvd in qliksense

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

5 Replies
Not applicable

Re: how to make qvd in qliksense

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

erikajain02
New Contributor II

Re: how to make qvd in qliksense

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;

tap
Contributor

Re: how to make qvd in qliksense

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.

Re: how to make qvd in qliksense

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

Employee
Employee

Re: how to make qvd in qliksense

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