Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QVD File Reload

Dear All, I manage Qlikview Management console to grant access to DOC CAL and User cal. I usually don't perform any activity in qvw, qvds. Recently I started receiving tickets to reload qvd files. How do I reload QVD from qlikview server? please help.

Product nameQMS Backend Core x64
Client Build Number11.0.11414.0
Target Platformx64
13 Replies
luis_pimentel
Partner - Creator III
Partner - Creator III

Follow Below Steps:

Step1 : Open Qlikview Managment Console

Step2 : Goto Documents Tab, Choose the document and then right hand side you will find the Reload Tab.

Step2 :  Goto That tab Schedule the Timings.

giakoum
Partner - Master II
Partner - Master II

There is no direct way to reload a qvd. It is created by a normal qvw file, and that is the one you need to reload. So you need to know which qvw creates which qvd files.

Not applicable
Author

Hi Kalpana

You may be interested in QVD creation supporting task added in QV 11. You can create a task which is used only for QVD creation without QVW required. It's available under System => Supporting Tasks => QVD Creation

Lukasz

giakoum
Partner - Master II
Partner - Master II

Thank you Lukasz! I did not know there was a thing like that

rahulgupta
Partner - Creator III
Partner - Creator III

Hi Kalpana,

In Qlikview Management Console, you will find a tab of external tasks containg Qvd Creation option(May be available with Publisher).

You have to make a connection string over there and write the SQL Query to load the table from the DB.

Rest you have to give the path of the qvd to be created and schedule it on timely basis.

Regards

Rahul

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Lukasz is correct about creating QVDs in the latest version of Publisher. If you only have Server or your load is a bit more complex you need to create the QVD in a standard .qvw file.

Load your table as normal and then issue this statement:

STORE TableName INTO MyQVD.qvd (QVD);

This will write the current contents of the table to a file. If you Google QVD STORE you should find plenty of information.

Steve

Not applicable
Author

Thank you. How do I reload a QVW file? I do find a qvw file.

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Does the QVW appear under Documents in QlikView server?  If so you can go to the Reload tab and set up a schedule for the reload.  Alternatively you can reload in Desktop, using the Reload button (this looks like a sheet of paper with a Green arrow on it).

- Steve

giakoum
Partner - Master II
Partner - Master II

Hi Kalpana.

Go with Steve's advise. However, I really belive you should read and take some training before you start administering a QV server. You could easily do a lot of damage.

Just a thought...