Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
FranciscoQ
Partner - Creator
Partner - Creator

Linking Tables

Hi !

I Have the next data model, a FACT table, some dim tables and there is also a budget table (the one named presupuesto), linked to one dimension (Product).

Fact is linked to product with productID, and product is linked with Presupuesto (Budget) with producto (which is the product name)

 

What I want to achieve is linked the the Fact date with Presupuesto date. Fact dates are daily dates while presupuesto are month year dates,

Let´s say I create a field monthyear and named it as %FECHA which is the key  date of FACT, I will have a ciircular reference because Fact will be linked to Presupuesto with the date, presupuesto to producto with Product, and producto with Fact by Product ID,

 

Any idea about how I can solve this issue ? Someone told me about link tables or generic keys, but I am not very sure about how to apply them

 

FranciscoQ_0-1631737486986.png

 

Thanks in advance !!

 

 

1 Reply
Gysbert_Wassenaar

I think you're looking for this: https://community.qlik.com/t5/Qlik-Design-Blog/Fact-Table-with-Mixed-Granularity/ba-p/1468238

 


talk is cheap, supply exceeds demand