Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Arianna-lab
Contributor

Load a File Qvd from my personal Space

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.

Ariannalab_0-1653397828769.png

Arianna

 

Labels (1)
1 Solution

Accepted Solutions
stevedark
Partner Ambassador/MVP

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

View solution in original post

1 Reply
stevedark
Partner Ambassador/MVP

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