Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Yes you can use a QVD file or also the same QVW file
// 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
t:
load * from t.qvd (qvd);
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.