QlikView App Dev

[#1]

Can we Join QVD files  ?

My understanding is,

- In report level, if the column names are same, it gets automatically joined

- And While preparing QVD's, we can able to join many tables and prepare as a QVD.

After creating QVD files, can we join the columns ? (Not Report Level)

Regards,

Praveen

[gupta_n8 · Accepted solution]

Yes , you an creating staging applications , where you can fetch data from datasource or previously built qvds and join them,

now you can create new qvd after joining two qvds:

example

Table:

Load customer, part_id,sale

from sale.qvd;

left join

load part_id,part_name

from part.qvd;

left join

load customer,customer_name

from customer_table.qvd;

store Table inot Sales_data.qvd;

Hope this helps.

Regards

Nitin

[#3]

Thanks Nitin

[walterlh]

Indique que la pregunta se ha respondido.

[gupta_n8]

Claim your question has been answered

[varunqvmm]

RegionMain:

LOAD RegionID ,
Continent,
Country
from [D:\QlikView\QVDS stored\Region.qvd](qvd);
Left Join (RegionMain)
LOAD
ProductID,
RegionID,
TimeID,
SupplierID,
Quantity,
DefectPercentage
from [D:\QlikView\QVDS stored\SupplierQuantity.qvd] (qvd);

STORE RegionMain into [D:\QlikView\QVDS stored\RegionMain.qvd];

I tried to join the following QVDs but  a script error is thrown saying that RegionMain table is not found.Can anyone give a solution on this