Load a File Qvd from my personal Space

Arianna-lab — Tue, 24 May 2022 13:29:45 GMT

Hello! I want to load a file qvd in Qlik Sense that contains several tables.

This file is located in my personal space. I am trying to use the Catalogue Data but I can't. Someone can help me?

Thanks in advance.

Arianna

Re: Load a File Qvd from my personal Space

stevedark — Fri, 27 May 2022 22:58:49 GMT

Hi @Arianna-lab

I find that some things are done much easier in the load script editor rather than using the other methods.

If the app has been created in the personal space then you can just refer to the QVD like this:

LOAD
*
FROM [lib://DataFiles/MyQVD.qvd] (qvd);

You can reference QVDs in other spaces by putting the space name before the library, separated by a colon, like this:

LOAD
*
FROM [lib://MySpace:DataFiles/MyQVD.qvd] (qvd);

One thing you can't do though is reference your personal space in that way, so if you want to load data from a different space to where the app resides you will need to create a space for the data.

Typically on any tenant I work in I will create a space called Data and store Connections, QVDs and QVD Generators in that space, separate to presentation apps. This way you can always reference data from anywhere (read or write) by using:

[lib://Data:DataFiles/MyQVD.qvd]

Likewise, you can reference connections in the same way:

LIB CONNECT TO 'Data:MySQLConnection';

Hope that makes sense and helps out?

Steve

topic Load a File Qvd from my personal Space in App Development

Load a File Qvd from my personal Space

Re: Load a File Qvd from my personal Space