topic Link table(urgent) in QlikView

Link table(urgent)

Wed, 19 Jun 2013 07:46:58 GMT

Hi all,

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.

Please help me with this.

Re: Link table(urgent)

vikasmahajan — Wed, 19 Jun 2013 08:00:15 GMT

Please refer demostration for the same.

Vikas

Re: Link table(urgent)

Wed, 19 Jun 2013 08:35:43 GMT

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?