Edit existing QVD file

[#1]

Good morning everyone,

We recently added a new dimension to our product table and now I need to add the new dimension to our existing QVD. When I google this all I get is a link to purchase a piece of software to do this. Surely I can do this without having to purchase additional software.

[MK_QSL]

Open the script which is used to create a QVD.

Add New Dimension and Override the QVD by storing the new on old..

[jonathandienst]

Harry

You just need Qlikview - Create a QVW document that opens the QVD, loads the new dimension values from whichever source you have. During the dimension load, do a left join to add the new field(s) and then store the QVD again into the same file name and location. (although I would backup the original first).

If this QVD is generated regularly (eg daily), then you will need to add the script code above to the QVD generator so that the new dimension gets added automatically.

HTH

Jonathan

[its_anandrjs]

You can add manually the product table like just update the QVD maker of product table like

Product:

Load

NewFieldName,  //////Add here (you need to add field name in the load script and update the QVD then you get this field

Fieldname1,

Fieldname2

From Location

Store Product into Product.qvd;

[#5]

That is my problem, we had consultants do our initial work and I am not sure where to find the scripts to build the QVD. When I open the QVD and add the new dimension and try to debug it does not see the new dimension.

Thanks,

Harry Standley | Business Systems Analyst | <http://www.georgesinc.com/> | PO Drawer G | Springdale AR 72765-2030

479.927.7127 | Help Desk: 479.927.7777 | harry.standley@georgesinc.com<mailto:harry.standley@georgesinc.com>

“You cannot manage what you cannot control. You cannot control what you cannot measure. You cannot measure what you cannot define” CSI book

[MK_QSL]

You can load the QVD to new QVW and all the new field and can do the left join as per Jonathan's reply.

[its_anandrjs]

Yes there is another way to do this as jonathan suggesting like

Product:

Load

ProductID, //UniqueKey

Fieldname1,

Fieldname2

From Location;

Left join

//New load of the fields ad new fields here

Load

ProductID,

NewFieldName

From Location;

Store Product into Product.qvd; //and store the table with this script

Note:- But you need unique key with new field

Regards

[ger_alegria]

Open a new QVW and load the QVD file. Add the new dimension in the script. If you have the dimension in other table, you can add the dimension using a commun field and the join command.

[Greg_Williams]

QVW = QlikView application File (qlikview workbook). The QVW file is used for four reasons:

1. Connects to data, 2. Models data (formatting, joins, cleansing, lookups, etc.), 3. Builds the User Interface (UI) (some call this the dashboard or front-end), lastly, 4. Creation of QVD files.

QVD = QlikView Data File   This is a highly compressed, proprietary QlikView file that represents a table of data. This table of data can be from numerous data sources (i.e. database tables, excel spreadsheets, both, etc.). QVD's are able to be reused (potentially) between different QVW files. QVDs are built using QlikView Desktop client (either 32-bit or 64-bit version). The QlikView Desktop client is a thick client and installed on your local machine or (in some cases) QlikView Server machine. Normally, the client is installed on a QlikView developer laptop. One can have any number of QVD files in a QlikView deployment.

QVD Usage:

Some general approaches to using QVDs. QVDs can be used to store historical data. They can be used to store departmental or different business unit data. It can be used to offset demand on needing to query the original database (or data source). It generally speaking, can be used to segregate your data anyway you want it sliced.

Possible scenario:

In QlikView Desktop client (a.k.a. "developer client" or "developer"), create a new QVW file and save it. File > Open Script Editor...Connect to your desired data source(s). At the top (at the beginning) of the Load statement, provide a name for the table (e.g. Sales or [Sales Performance] (note - [ ] brackets are used when there is a space in the name of a field or table). At the end of the Load statement, to create a QVD, type: Store [Name of Table - described above] into [folder\file name.qvd]; So it might appear something like: store [Sales Performance] into ; Instead of using an absolute path, this can be substituted with a relative path (UNC naming convention, which is preferred, normally). Select Reload. This will create a QVD file in that path specified on the Store statement line. In Windows Explorer, open the folder with the QVD file and observe the file Sales Performance.qvd. Note the size of the file > should be compressed.

If the QVD file is missing some data, return to the *.qvw file that created it...if one does not exist or the file cannot be located, you can create another QVD from scratch (as described above). One might choose to comment out the old script, Connect to the desired data, Select new / different fields, enter them into the Edit Script tab, and Reload. The new (or modified) QVD file will appear (where you identified where to store it).

Hope this Helps you.

~Greg