Read QVD File

[#1]

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

[ogster1974]

What is the error?

[#3]

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]

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

[Anonymous]

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

[#6]

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]

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]

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

[#9]

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]

Jesus,

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

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

Regards,

Vlad