topic Re: Read QVD File in Visualization and Usability

Read QVD File

Sat, 18 Feb 2017 17:11:11 GMT

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

Re: Read QVD File

ogster1974 — Sat, 18 Feb 2017 23:23:49 GMT

What is the error?

Re: Read QVD File

Sat, 18 Feb 2017 23:40:01 GMT

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,

Re: Read QVD File

ahaahaaha — Mon, 20 Feb 2017 08:47:35 GMT

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

Re: Read QVD File

Anonymous — Mon, 20 Feb 2017 12:34:14 GMT

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

Re: Read QVD File

Mon, 20 Feb 2017 13:46:50 GMT

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?

Re: Read QVD File

ogster1974 — Mon, 20 Feb 2017 14:08:12 GMT

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.

Re: Read QVD File

vlad_komarov — Mon, 20 Feb 2017 14:09:13 GMT

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...

Re: Read QVD File

Mon, 20 Feb 2017 14:25:04 GMT

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.

Re: Read QVD File

vlad_komarov — Mon, 20 Feb 2017 14:29:53 GMT

Jesus,

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

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

Regards,

Vlad

Re: Read QVD File

Mon, 20 Feb 2017 14:38:17 GMT

I´m doing it that way Vlad, thank you for your reply.