Just a question regarding creating the schema in Qlikview. I have this kind of table:
I have a reference table (Product Reference Table) and I need to connect it to the 2 detail tables. The thing is, the reference table is also one of the filters so I did not left join the reference table to the details. How am I going to achieve this? The product reference table consist of the product code and the product description. How am I gonna connect it without having a circular problem on my source.
Can you use concatenate to merge the header tables to a single table with some common fields and then concatenate the detail tables to have a common product key but different measures. This will simplify the associations.