Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

asknyldz
New Contributor III

Joinning 3 Tables and missing data

Hi everyone.

I'm joinning 3 table and then there is missing data. I see only one rows value in totals. You can below data and script.

MercuryData:

SEGMENTBUSINESS UNITSPECIALTYTYPEMONTHAMOUNT
Risk ManagementMcsPropertyACTUALApr-19600
Risk ManagementMcsPropertyACTUALFeb-19

600

 

Script;

LOAD
[SEGMENT],
[BUSINESS UNIT],
[SPECIALTY],
[TYPE],
[MONTH],
[AMOUNT]
FROM
[MercuryData.xlsx]
(ooxml, embedded labels, table is [MercuryData]);

JOIN

LOAD
[SEGMENT],
[BUSINESS UNIT],
[SPECIALTY],
[Team],
UPPER([Team]) as Team_SA
FROM
[MarshForce.xlsx]
(ooxml, embedded labels, table is [MappingMer]);

LOAD
[Opportunity Value (converted)],
[MF_Business Unit],
[Product Line],
[Line of Business],
[Line of Coverage],
[Weighted Amount (converted)],
[Close Month] as [MONTH],
[Funnel Stage],
[Team]
FROM
[MarshForce.xlsx]
(ooxml, embedded labels, table is [MFData]);

 

1 Reply
Partner
Partner

Re: Joinning 3 Tables and missing data

Can you provide a sample qvw?