Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 name | QMS Backend Core x64 | ||
Client Build Number | 11.0.11414.0 | ||
Target Platform | x64 |
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.
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.
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
Thank you Lukasz! I did not know there was a thing like that
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
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
Thank you. How do I reload a QVW file? I do find a qvw file.
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
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...