adding a new column to an exisiting qvd

Mon, 03 Feb 2014 16:31:08 GMT

I have a qvd of data that I complied. In that QVD I have 3 different calculations where I save them as new columns ( mg, grams,mg/kg).

Next I created a new table name and loaded loaded that qvd, and summed each of the three values sum(grams) + sum(mg)+(mg/kg) and saved it to a new column named totalGrams

I loaded from resident table and grouped by 3 distinct columns.

I have 6 qvds and would like to be able to create a new column for the total grams

Is there a way I can add that new column to the qvd?

Re: adding a new column to an exisiting qvd

Mon, 03 Feb 2014 16:40:53 GMT

You create the QVD with the STORE command

Your QVD will contain only ONE table

When you export the table, you may export the whole table or only some fields (that you can rename by the way).

So, you need to overwrite the QVD: you load it into a table, you modify the table (add column), you export the table (STORE) into the existing QVD by overwritting it

Fabrice

topic Re: adding a new column to an exisiting qvd in QlikView

adding a new column to an exisiting qvd

Re: adding a new column to an exisiting qvd