Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Merging Two Dashboard into single one.

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
9 Replies
Not applicable

open one dashboard add a button -action- external-open qlikview dashboard -pass the name of 2nd qlikview document ex: write SalesDashboard.qvw

Not applicable

or you can perform join/concatenation as per data

deepakqlikview_123
Specialist
Specialist
Author

Hi Shweta,

Can you please suggest where should I join on concatenate in thsi.

Thanks,

Not applicable

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

its_anandrjs

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

shaik_basha
Creator III
Creator III

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

vardhancse
Specialist III
Specialist III

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

amit_saini
Master III
Master III

Hi Deepak,

You can use "Binary Load" here in this case. Call first dashboard through binary load in second dashboard.

Thanks,

AS

Not applicable

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....