Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Qliksense: Load Data Into QVD

I am currently using the Qliksense platform and not Qliksense Desktop.

I am new to this tool and attempting to load date from our MSSQL database to QVD, however I do not understand why I cannot store it into a Directory or Lib? What is the Lib path. There seems to be a lack of documentation and I cannot seem to find a way to load this data.

Also what would be the best approach. Would I have one app just dedicated to loading all data? i.E if I wanted to perform data refresh nightly?

Here is my current script:

DailyInventory:

LOAD

InventoryKey,

OwnedQty,

Warehouse,

WarehouseKey,

Date;

SQL SELECT

InventoryKey,

OwnedQty,

Warehouse,

WarehouseKey,

Date

FROM RentalworksDW.dbo.DailyInventoryStatus;

STORE DailyInventory INTO [lib://QlikSenseQVDFiles\DailyInventory.qvd](QVD);

What is this lib:\\path?

I tried C:\QlikSenseQVDFiles\DailyInventory.qvd](QVD) that did not seem to work either.

1 Solution

Accepted Solutions
reddys310
Honored Contributor II

Re: Qliksense: Load Data Into QVD

Hi A Sma,

The mistake you are making here is you are not providing the entire library connection name.

it has to be 'lib://QlikQVDs(xxxxxxxx)/warehouse.qvd'

You user name is default suffixed to the connection you create. Hence you need to add that as well. If you want to get rid of the suffix, you need to do it from QMC->Connections.

Thanks,

Sangram.

9 Replies
Not applicable

Re: Qliksense: Load Data Into QVD

The "folder" name that appears after the lib:// is the name of your "connection".  Look on the right side of your screen in the area labeled "Connections".  You can add a connection that defines the path to your desired folder. Remember, the path must be accessible by the Qlik server. Create a connection named QlikSenseQVDFiles. Configure with the path to your file folder. Then in the load script place the connection name after lib://

Example:  Store DailyInventory into [lib://QlikSenseQVDFiles/DailyInventory.qvd](qvd);

Not applicable

Re: Qliksense: Load Data Into QVD

To answer "Also what would be the best approach. Would I have one app just dedicated to loading all data? i.E if I wanted to perform data refresh nightly?"  You can have one app that loads the data from the MSSQL database and then stores the data as a QVD file. Set this app up for a daily refresh in QMC Tasks.  Then, other apps can load the saved QVD file. You would also set up QMC Tasks to load the saved data(QVD) for each of those apps.

reddys310
Honored Contributor II

Re: Qliksense: Load Data Into QVD

Hi Asma,

The [LIB:\\<Connection Name>\...] refers to the connection you created in the connections pane. Its basically like an alias to the entire file path.

So the store command creates a QVD file and stores it to the location you have created in the data Connections.

Thanks,

Sangram.

Not applicable

Re: Qliksense: Load Data Into QVD

Hi Sangram. Thanks for the detailed explanation. I tried creating the connection folder. And then tried to store data into it and I get the following error. I am not entirely sure why. Are there any other permissions that may be missing? Please take a look at the screenshot below. Screen Shot 2016-02-07 at 10.33.57 PM.png

reddys310
Honored Contributor II

Re: Qliksense: Load Data Into QVD

Hi A Sma,

The mistake you are making here is you are not providing the entire library connection name.

it has to be 'lib://QlikQVDs(xxxxxxxx)/warehouse.qvd'

You user name is default suffixed to the connection you create. Hence you need to add that as well. If you want to get rid of the suffix, you need to do it from QMC->Connections.

Thanks,

Sangram.

undergrinder
Valued Contributor II

Re: Qliksense: Load Data Into QVD

Hi ASma,

I guess it's caused due to he connection name.

Your connection name is not only "QlikQVD" , but "QlikQVD (username)".

You can change the connection name in QMC, or try insert a table through this connection, and observe what connection string will be inserted in the script.

G.

Not applicable

Re: Qliksense: Load Data Into QVD

Thank you This worked.

oknotsen
Honored Contributor III

Re: Qliksense: Load Data Into QVD

If your question is now answered, please flag the Correct Answer. If not, please make clear what part of your question you still need help with.

May you live in interesting times!
reddys310
Honored Contributor II

Re: Qliksense: Load Data Into QVD

Always Welcome!

Community Browser