Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
I should do a concatenate between those two tables.
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.
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
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]
if number of fields are same qlikview will perform automatically the concatenation else u can do manually as well by using concatenate.