Combine data from facts to aggragate facts with same dimensions

[#1]

I have 1 fact table with Some measures, and I have another fact table with these measures aggrateted with Some new measures that only make point in aggragate version.

I need to use these both together in qlik. And also combine them with same dimentions since I have to use the same filters on both.

How can I do it? Need step by step ansser here since I am new in Qlik.

fact table:

companyname1,  organisation1, JULY, 2016, 1500, 23.07.2016

companyname1,  organisation1, JULY, 2016, 1500, 23.07.2016

companyname1,  organisation1, JULY, 2016, 1500, 23.07.2016

companyname1,  organisation1, JULY, 2016, 1500, 23.07.2016

aggregate table:

companyname1, organisation1, JULY, 2016, 6000,1000,200

dimension table1

companyname1, hdjeubeve

DImension table2:

organisation1, 637373, 15

the report should be like:

hdjeubeve,  637373, JULY, 2016, 6000, 1000, 200, 23.07.2016

‌

[thomaslg_wq]

Maybe with this script :

// Fact table load + creating key that will match with aggregate

Fact:

LOAD

autonumber(CompanyName&'/'&OrganisationName&'/'&Period) as %Key,

CompanyName,

OrganisationName,

Period,

Date,

Value1,

Value2,

Value 3

FROM SOURCEFACT;

// Adding Values of Aggregate in fact in case there are some values of

// aggregate that do not match with the ones from fact

outer join(Fact)

LOAD distinct

autonumber(CompanyName&'/'&OrganisationName&'/'&Period) as %Key,

CompanyName,

OrganisationName,

Period

FROM SOURCEAGGREGATE;

// Creating key to match with dimensions in fact + value aggregate

Aggregate_Table:

LOAD

autonumber(CompanyName&'/'&OrganisationName&'/'&Period) as %Key,

Value4,

Value5,

Value6

FROM SOURCEAGGREGATE;