2 tables with 2 common dimensions

pgriesbach — Sat, 23 Feb 2019 05:19:07 GMT

Hello

How do load the script for these 2 tables to avoid synthetic keys. I have tried adding a month table, a provider table and a measure table. I keep getting this error; One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. Loop(s) will be cut by setting one or more tables as loosely coupled.

this is my first request for help..I'm stuck, please advise.

I have 2 tables - first table

month provider

201808 provider01

201809 provider02

second table

201808 provider01 measure01

201809 provider01 measure02

I also want to have a way to use a monthyear like aug 2018 that pulls data from both tables for the monthyear selected.

Re: 2 tables with 2 common dimensions

Claudiu_Anghelescu — Sat, 23 Feb 2019 08:20:22 GMT

Table1:

month provider

201808 provider01

201809 provider02

Table2:

month provider_t2 measure

201808 provider01 measure01

201809 provider01 measure02

Changing the header un the Table2 you don't have the synthetic key.

topic Re: 2 tables with 2 common dimensions in QlikView

2 tables with 2 common dimensions

Re: 2 tables with 2 common dimensions