I have created a data model in qlikview with the help of link tables. But when i am trying to fetch data from two different facts it is not giving me any data.
The two fact tables are:
FACT1: Link_ID1, Metric value
FACT2: Link_ID2, Metric1 value
Link Table: Link_ID1, Link_ID2, PROF_SK, PROD_SK, CHNL_SK, ACTIVITY_SK
DIM_CHNL: CHNL_SK, CHNL_NM
DIM_ACT: ACTIVITY_SK, ACTIVITY_NAME
Link_ID1 consists of PROF_SK, PROD_SK, CHNL_SK
Link_ID2 consists of PROF_SK, PROD_SK, ACTIVITY_SK
Now i want to show a chart with channel name and activity name and Metric value. But i am not able to do that, it is not showing me any data in the chart.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
But the problem in my case is I will have have to join FACT1 and FACT2 for my chart on Prof_SK and PROD_Sk and then i will have to join DIM_ACT and DIM_CHNL with them becuase i do not have both the SKs in any of the fact table. How can i do that?
