Hi community I know this type of question sounds repetitive but I'm really newbie at Qlik and I just need a minimal guidance, because I've read so much techniques and best practices that I'm kind of lost now...
I have the following hierarchies in different files:
I want to associate the three tables, so I created a composite key (AutoNumber) between Date, Father and Child to associate the first two tables, and it worked fine. In a fact table I have put all the different facts and this key that links the two tables, and dropped the fields from the respective tables. I also have a Master Calendar with the Date key field.
But now I'm tring to do the same thing between table1 and table3, but somehow the Date, GrandFather and Father composite key is not the same in the two tables, so it doesn't link them...
What are the options in terms of modeling this type of situationn? Generic Keys and Link Tables?
Please offer some advice, however trivial it may sound.
for schema that work well with Qlik dashboards you should investigate star and snowflake schema.
in this case your requirement doesn't need seperate dimension tables as no unique dimensional attributes identified. a dates a date its the fact it relates to that gives it context. you could actually have a field called fact type and just a value field if you wanted to reduce the model some more.
I have applied your solution of concatenating it all, and it worked! At least for now
So, when you say that my dimension tables have no unique dimensional attributes identified, you are referring to fields that describe the table, right? For example, if I had a Customer table with lots and lots of attributes, like
then, in that case, it would make sense to have a separate table, not concatenated to the facts but rather joined? Is that what you are saying?