topic Re: Creating a QVD in QlikView

Creating a QVD

Anonymous — Fri, 15 Aug 2014 16:06:08 GMT

Hello,

I have created a table in a QVW with numerous dimensions and expressions. I would like to use this table in another QVW and was wondering how I would be able to do this. I believe I have to create a QVD and then load the QVD into the second QVW but I am not certain.

Any help would be greatly appreciated.

Thanks,

Isabel

Re: Creating a QVD

ecolomer — Fri, 15 Aug 2014 16:09:23 GMT

Yes you can use a QVD file or also the same QVW file

Re: Creating a QVD

maxgro — Fri, 15 Aug 2014 16:14:29 GMT

// store the table (I suppose t is the table) in a qvd in the first QVW

store t into t.qvd (qvd);

// read the qvd with the table in second QVW

load * from t.qvd (qvd);

Re: Creating a QVD

Fri, 15 Aug 2014 16:19:17 GMT

Hi,

Yes you can use this table from QVW 1 into QVW 2, you need create QVD file and this is an exmaple:

FactTable:

LOAD

Dimension1,

Dimension2,

Dimension3,

Metric1,

Metric2,

MatricN

From myfile.xlsx;

Store FactTable into FactTable.qvd; // With this you can create the QVD.

or if you create a Straigth Table (chart) in Desing Area and you need this chart in QVD file you need a macro using export function.

Best regards.