Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Read QVD File

Hi guys, I´m trying to read data for a QVD file, I found an example in the community which basically looks like this, but i´,ve not been able to get it done, can you help me about this error.

Thank you in advance.

Table01:

  LOAD

      Key,

      name

  FROM

  (qvd);

Tags (1)
10 Replies
ogster1974
Not applicable

Re: Read QVD File

What is the error?

Not applicable

Re: Read QVD File

Some QVDs I've seen have security still on them and going from server to desktop they won't load because of that. Like Andy said can you give us the error message. It would help us help you better,

T. 

ahaahaaha
Not applicable

Re: Read QVD File

Hi Jesus,

You path "FROM" for QlikView used to Qlik Sense. At Qlik Sense, you must create a connection to the folder [C:\Users\user01\Documents\Qlik\Sense\Apps\Test\2.QVD], and then have to apply to the file [Data_01.qvd].

If the newly created connection you call, for example, [QVD], then your code would look like this

Table01:

  LOAD

      Key,

      name

FROM [lib://QVD/Data_01.qvd]

(qvd);

Regards,

Andrey

giulioandrea
Not applicable

Re: Read QVD File

Do you have to create a connection on your computer qliksense could not read your directory name.

Not applicable

Re: Read QVD File

Thank you for the reply guys, I´m working with Qlik Sense, it´s necessary to create a folder connection then? It cannot be achieved without it?

ogster1974
Not applicable

Re: Read QVD File

Yes you have to define the location for your QVDs in a library but the QVDs you load in from there can be set dynamically even which library you use can be decided during the load.

vlad_komarov
Not applicable

Re: Read QVD File

You can use a "Legacy mode" in QlikSense (which helps you to avoid a "Folder Connector"),  but it's global option, so all of your scripts will be forced to use it...

VK

Not applicable

Re: Read QVD File

Thank you for the help guys, I´m doing this to lower modification impact.

1. Created a folder connection.

2. Set a variable with the connection.

3. Use this variable in the LOAD ... FROM.

If you have a better suggestion I´ll be glad to hear from you.

vlad_komarov
Not applicable

Re: Read QVD File

Jesus,

Good idea... Just make sure you are passing a variable as a string:

FROM '$(TransformationsLibrary)/XXXXXX.qvd' (QVD);

Regards,

Vlad