topic Re: How to Modify an Existing .QVD File? in QlikView

How to Modify an Existing .QVD File?

Fri, 19 Jul 2013 14:59:58 GMT

So I apologise ahead of time if this is a dumb question, but I'm super new to QlikView and I'm really in a bind.

The person who used to manage QlikView at my company has just left and I'm now in charge of keeping the documents functioning.

I discovered a problem with a connection string in one of the .qvd files that loads into a .qvw, however I can't for the life of me figure out how to modify this file.

The database it was using to obtain information was moved to another server, and I need to make that change in the .qvd.

Could someone explain to me how to open an existing qvd and change the connection string in the script?

Your help would be greatly appreciated.

Thanks.

Re: How to Modify an Existing .QVD File?

rwunderlich — Fri, 19 Jul 2013 15:08:57 GMT

QVDs are created by the STORE statement in a qvw script. So find the QVW that creates the QVD, and change the connection string in that script.

-Rob

Re: How to Modify an Existing .QVD File?

luciancotea — Fri, 19 Jul 2013 15:16:41 GMT

As Rob sugested, find which QVW is generating your QVD.

Just to strictly answer the question, there is a tool to edit QVDs: http://www.etl-tools.com/products/q-eye-overview.html

Re: How to Modify an Existing .QVD File?

Fri, 19 Jul 2013 15:25:20 GMT

Hmm..I downloaded that tool but I couldn't figure out hwo to edit a connection string from it.

I found the QVW that loads the QVD I'm looking for, and I managed to find the tab for the QVD after a bit of digging.

I started modifying the connection string, and noticed something called [Xpassword] at the end.

What is this password used for? and is it uniqe for each QVD, or each server connection? Should I leave it as is, or do I need to obtain the XPassword for the new server I'm trying to connect to?

I'm getting there! Although it's baby steps!

Thanks again to both of you.

Re: How to Modify an Existing .QVD File?

luciancotea — Fri, 19 Jul 2013 15:35:56 GMT

OK, let's get something straight:

QVW = QlikView Document. Contains: All the tables, Script, Reports, Macros, Alerts,.. and Interface Objects.

QVD = QlikView Data. Contains the data from one table.

I suggest that you should get help from a QlikView developer to debug the applications.

Re: How to Modify an Existing .QVD File?

Fri, 19 Jul 2013 16:19:32 GMT

The answer is, you have to delete or comment out the existing connection line in the top of the script in your qvd, and create a new one via the connection dialog box at the bottom left of the window.

The XPassword is automatically generated by Qlikview each time you create a connection to a data source.

Thanks for the help Lucian. Oh, wait...