Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
Not applicable

A question of Modelling with multiple fact tables? Need help or direction


I have what I think is a modelling issue. My current knowledge doesn't allow me to find a working and sustainable solution. I'm sure ou can help me find that solution, or at worst provide me direction to find it.

So here is my question.

I currently have the following model :


Basically, Target and ProductionInf would be fact tables and the others tables would be dimensions.

I need to design a graph that would look like the following which consists in comparing target value with actual production value:


My target is defined by location and month.

My production is defined by machine and every 10-minuts.

To do this graph I would need to join my target table to my calendar (the field OBJ_MONTH is a date).

Unfortunately, I have two different level of aggregation and a direct link would create a loop.

Do not hesitate to ask me questions if you think I was not clear enough.

I provide a QlikView app and source files with faked data in hope it will help for helping me.

Thanks for your help!!!


0 Replies