topic Re: Merging Two Dashboard into single one. in QlikView

Merging Two Dashboard into single one.

deepakqlikview_123 — Thu, 26 Jun 2014 05:14:19 GMT

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

Re: Merging Two Dashboard into single one.

Thu, 26 Jun 2014 05:38:15 GMT

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

Re: Merging Two Dashboard into single one.

Thu, 26 Jun 2014 05:39:06 GMT

or you can perform join/concatenation as per data

Re: Merging Two Dashboard into single one.

deepakqlikview_123 — Thu, 26 Jun 2014 05:41:18 GMT

Hi Shweta,

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

Thanks,

Re: Merging Two Dashboard into single one.

Thu, 26 Jun 2014 05:52:29 GMT

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

Re: Merging Two Dashboard into single one.

its_anandrjs — Thu, 26 Jun 2014 06:38:12 GMT

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

Re: Merging Two Dashboard into single one.

Anonymous — Thu, 26 Jun 2014 08:27:39 GMT

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

Re: Merging Two Dashboard into single one.

vardhancse — Thu, 26 Jun 2014 09:23:11 GMT

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

Re: Merging Two Dashboard into single one.

amit_saini — Thu, 26 Jun 2014 09:33:01 GMT

Hi Deepak,

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

Thanks,

Re: Merging Two Dashboard into single one.

Thu, 26 Jun 2014 09:45:08 GMT

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