Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Re: Synthetic Key Issue

Let me know the relationship of your fact table with DimCurrency & Dimlocation is one-to-one then i will let you know another solution

Highlighted
Partner
Partner

Re: Synthetic Key Issue

You concatenate your two fact tables and have them share the keys for country and currency.  Instead of qualifying your fields like

FKFact_SalesTakenAt and FKFact_ParlSales

Call them both Sales and add another field to your tables called FactType or similar with the values 'TakenAt' and 'Park' respectively.

Fact:

Load FKDim_Location as %LocationKey,

           FKDim_Currency as %CurrencyKey

           FKFact_ParkSales as Sales,

  .

.

.

           'Park' as FactType

from ParkFacts.....;

Concatenate(Fact)

Load FKDim_Location as %LocationKey,

           FKDim_Curency as %CurrencyKey

          FKFact_SalesTakenAt as Sales

.

.

.

.      'TakenAt' as FactType

from TakenAtFacts.....;

DimLocations:
Load FK_DimLocation as %LocationKey

.

.

.

.

.

From DimLocations ....;

You get the picture.

When your model is like this then expressions become:

Sum({<FactType={Park}>} Sales)

and

sum([<FactType= {TakenAt}>} Sales)

Selecting a coutntry will link to both the row with factType Park and the one with factType TakenAt

Highlighted
Not applicable

Re: Synthetic Key Issue

Hi,

you will try by using "Aliasing"

thanks,

krish

Highlighted
Partner
Partner

Re: Synthetic Key Issue

Hi Miles,

Is it possible to share your file with some data?

Or create 4 excel or CSV files with some data (but containing all fields).

Make sure your sample data makes sense..

What (field) is the relation between FactParkSales and FactParkSalesTakenAt?

Grtz. Fred

Highlighted
Creator II
Creator II

Re: Synthetic Key Issue

You can also use Generic Keys