topic HOW TO JOIN TWO QVD FILE in QlikView

HOW TO JOIN TWO QVD FILE

sagaraperera — Fri, 10 Apr 2015 08:30:07 GMT

I Want to conect two qvd file in one qlickview file with crosstable how to do this please help

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

MONM,

GROSS_PREMIUM,

SRCC_PREMIUM,

REINSURANCE_FUND,

FOREIGN_COMPANIES,

CEEDED_PREMIUM,

NRP,

UPR_CHARGE,

NEP,

SRCC_TC_COMMISSION,

FOREIGN_CO_COMMISSION,

COMMISSION_INCOME,

NET_REVENUE,

GROSS_CLAIMS,

CLAIMS_RES_FUND,

EXGRATIA_CLIMS_RES_FUND,

CLAIMS_PROCESSING_EXPENSES,

LEGAL_FEES,

RI_RECOVERIES_RI_FUND,

RI_RECOVERIES_SRCC_TC,

RI_RECOVERIES_FOREIGN,

SALVAGE_RECOVERIES,

NET_CLAIMS,

COMMISSION_EXPENSES,

PRODUCTION_BONUS,

DAC_CHARGE,

ACQUISITION_COST,

GROSS_PROFIT,

STAFF_EXPENSES,

ADMIN_EXPENSES,

SELLING_EXPENSES,

FINANCIAL_EXPENSES,

DEPRICIATION_EXPENSES,

MANAGEMENT_EXPENSES,

INV_INCOME_EXT,

INV_INCOME_INT,

OTHER_INCOME_EXT,

OTHER_INCOME_INT,

INV_OTHER_INCOME,

NET_PROFIT

FROM

[..\..\qlickviwe\P&L\P&LBUDDATA2011_2014.QVD]

(qvd);

Directory;

CrossTable(DESCRIPTION, BUDGET, 6)

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

MONM,

GROSS_PREMIUM,

SRCC_PREMIUM,

REINSURANCE_FUND,

FOREIGN_COMPANIES,

CEEDED_PREMIUM,

NRP,

UPR_CHARGE,

NEP,

SRCC_TC_COMMISSION,

FOREIGN_CO_COMMISSION,

COMMISSION_INCOME,

NET_REVENUE,

GROSS_CLAIMS,

CLAIMS_RES_FUND,

EXGRATIA_CLIMS_RES_FUND,

CLAIMS_PROCESSING_EXPENSES,

LEGAL_FEES,

RI_RECOVERIES_RI_FUND,

RI_RECOVERIES_SRCC_TC,

RI_RECOVERIES_FOREIGN,

SALVAGE_RECOVERIES,

NET_CLAIMS,

COMMISSION_EXPENSES,

PRODUCTION_BONUS,

DAC_CHARGE,

ACQUISITION_COST,

GROSS_PROFIT,

STAFF_EXPENSES,

ADMIN_EXPENSES,

SELLING_EXPENSES,

FINANCIAL_EXPENSES,

DEPRICIATION_EXPENSES,

MANAGEMENT_EXPENSES,

INV_INCOME_EXT,

INV_INCOME_INT,

OTHER_INCOME_EXT,

OTHER_INCOME_INT,

INV_OTHER_INCOME,

NET_PROFIT

FROM

[..\..\qlickviwe\P&L\P&LBUDDATA2015.QVD]

sagara

Re: HOW TO JOIN TWO QVD FILE

stabben23 — Fri, 10 Apr 2015 08:34:54 GMT

Hi,

I should do a concatenate between those two tables.

Re: HOW TO JOIN TWO QVD FILE

ashwanin — Fri, 10 Apr 2015 08:42:15 GMT

Hi Sagera,

In both QVD's ,field names seems to be same. Now if you load both QVD's then QlikView will automatically connect them.

Re: HOW TO JOIN TWO QVD FILE

rajkumarb — Fri, 10 Apr 2015 08:48:46 GMT

HI Sagara

BY Default if all fields are same between the two tables, Qlikview automatically concatenates the two tables into one Table after reload

(or if)

there are few fields same between two tables they join by the common fields by a link showing in Table viewer

if more than one field is common between two tables synthetic Keys will be formed

Hope that helps

Re: HOW TO JOIN TWO QVD FILE

mrossoit — Fri, 10 Apr 2015 08:52:14 GMT

You have to add crosstable statement also before the first load.

Try this:

Budget:

CrossTable(DESCRIPTION, BUDGET, 6)

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

MONM,

GROSS_PREMIUM,

SRCC_PREMIUM,

REINSURANCE_FUND,

FOREIGN_COMPANIES,

CEEDED_PREMIUM,

NRP,

UPR_CHARGE,

NEP,

SRCC_TC_COMMISSION,

FOREIGN_CO_COMMISSION,

COMMISSION_INCOME,

NET_REVENUE,

GROSS_CLAIMS,

CLAIMS_RES_FUND,

EXGRATIA_CLIMS_RES_FUND,

CLAIMS_PROCESSING_EXPENSES,

LEGAL_FEES,

RI_RECOVERIES_RI_FUND,

RI_RECOVERIES_SRCC_TC,

RI_RECOVERIES_FOREIGN,

SALVAGE_RECOVERIES,

NET_CLAIMS,

COMMISSION_EXPENSES,

PRODUCTION_BONUS,

DAC_CHARGE,

ACQUISITION_COST,

GROSS_PROFIT,

STAFF_EXPENSES,

ADMIN_EXPENSES,

SELLING_EXPENSES,

FINANCIAL_EXPENSES,

DEPRICIATION_EXPENSES,

MANAGEMENT_EXPENSES,

INV_INCOME_EXT,

INV_INCOME_INT,

OTHER_INCOME_EXT,

OTHER_INCOME_INT,

INV_OTHER_INCOME,

NET_PROFIT

FROM

[..\..\qlickviwe\P&L\P&LBUDDATA2011_2014.QVD]

(qvd);

concatenate

CrossTable(DESCRIPTION, BUDGET, 6)

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

MONM,

GROSS_PREMIUM,

SRCC_PREMIUM,

REINSURANCE_FUND,

FOREIGN_COMPANIES,

CEEDED_PREMIUM,

NRP,

UPR_CHARGE,

NEP,

SRCC_TC_COMMISSION,

FOREIGN_CO_COMMISSION,

COMMISSION_INCOME,

NET_REVENUE,

GROSS_CLAIMS,

CLAIMS_RES_FUND,

EXGRATIA_CLIMS_RES_FUND,

CLAIMS_PROCESSING_EXPENSES,

LEGAL_FEES,

RI_RECOVERIES_RI_FUND,

RI_RECOVERIES_SRCC_TC,

RI_RECOVERIES_FOREIGN,

SALVAGE_RECOVERIES,

NET_CLAIMS,

COMMISSION_EXPENSES,

PRODUCTION_BONUS,

DAC_CHARGE,

ACQUISITION_COST,

GROSS_PROFIT,

STAFF_EXPENSES,

ADMIN_EXPENSES,

SELLING_EXPENSES,

FINANCIAL_EXPENSES,

DEPRICIATION_EXPENSES,

MANAGEMENT_EXPENSES,

INV_INCOME_EXT,

INV_INCOME_INT,

OTHER_INCOME_EXT,

OTHER_INCOME_INT,

INV_OTHER_INCOME,

NET_PROFIT

FROM

[..\..\qlickviwe\P&L\P&LBUDDATA2015.QVD]

Re: HOW TO JOIN TWO QVD FILE

buzzy996 — Fri, 10 Apr 2015 08:58:44 GMT

if number of fields are same qlikview will perform automatically the concatenation else u can do manually as well by using concatenate.