Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please find attachment.I have pasted the code for both QVW file into the same.
I have two QVW file having some of tables same.As per business requirement i need to attach both QVW file into single QVW file.
Below are list of tables that we used in both dashboard.Can you please suggest what changes I have to do in this.
CDMSDashboard |
AreaMaster |
BrokerMaster |
ColorOfVehicle |
ColourMaster |
CountryMaster |
DealerMapping |
DepartMentMaster |
DepartmentPaymentCapacityMaster |
DistrictMaster |
EndUseMaster |
EnquiryAtMaster |
EnquiryMaster |
EnquirySource_EnquiryAt |
EnquirySourceMaster |
EnquiryStatus |
FinancierMaster |
FollowupPeriodMaster |
FollowupRegister |
ModelTypeMaster |
MSBRCReportModelHead |
OrganizationMaster |
OutletMaster |
OwnershipSegMent |
ReasonForBuyingMaster |
ReasonForPurchasingMaster |
RegionMaster |
StateMaster |
SubAReaMaster |
VehicleModelMaster |
VehicleSubModelMaster |
VehicleTypeMaster |
ZoneMaster |
CDMSBillingStock |
Billing |
BillingAgeing |
Cal |
ColorMaster |
CountryMaster |
DealerMapping |
DistrictMaster |
ModelTypeMaster |
MSBRC_ReportModelHead |
MSBRCReportModelHead |
OrganizationMaster |
RegionMaster |
SortDayAgeing |
StateMaster |
Stock |
StockAgeing2 |
VehicleMaster |
VehicleModel |
VehicleSubModelMaster |
VehicleTypeMaster |
ZoneMaster |
open one dashboard add a button -action- external-open qlikview dashboard -pass the name of 2nd qlikview document ex: write SalesDashboard.qvw
or you can perform join/concatenation as per data
Hi Shweta,
Can you please suggest where should I join on concatenate in thsi.
Thanks,
analysis the value of the field with same name.
if all the value are same you can comment that particular field from other table or if all value are not same either concate/join
For taking this table in the single QVW you have to do some changes in the tables which are same and identical in nature and exactly same field names. So in earlier stage add a flag field in the QVD generator for the tables and suppose you are using the separate QVDs then use Flag field with the expression and if you use the fields in the single QVW then do not use the flag field there. And when creating the QVD use joins and aggregate the data in the script level and use the table as QVD.
See small example
Table1:
LOAD * Inline
[
Id,Sale,Flag
A,15852,1
B,15478,1
C,12563,1
];
Table2:
LOAD * Inline
[
Id,Sale,Flag
F,45863,2
R,4582,2
G,25693,2
];
If you use the expression in single QVW then use expression like sum( Sale )
And if you use in the different QVW then Sum({<Flag={1}>} Sale) and Sum({<Flag={2}>} Sale)
Hope this helps
Hi Deepak,
i found some of tables are same in both the models,but here i have small doubt ,any common dimension based do you want to create a objects,like based month in one chart you have to display CDMSDashboard and CDMSBillingStock data,the you have to tack care what are the common tables between both the dash board.
and can you please explain what are common tables between both dashboards.
Thanks
SHAIK
after loading any tables we need to consider the below points:
1. same field name-it will form synthetic keys if there are more than 1 field name in common
2. can able to join the tables based on any field-we can do inner,left join/keep
based on requirement
Hi Deepak,
You can use "Binary Load" here in this case. Call first dashboard through binary load in second dashboard.
Thanks,
AS
Hi,
The best way is to use binary load ( open the qvw2 and use binary load of qvw1...
or else generate qvd for qvw1 and then use in qvw2...
then you can play around what you need....