Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Need Help on Data Modeling.

Hi Friends ,

I have a situation

I have basically 8 Tables which are linked 2 by 2 , you can ssee in below image

  • Site Table is linked with Site ,
  • SubSegment is linked with SubSegment
  • Segment is linked with Segment
  • Corporate is linked with Corporate

Issue Data Model.png

So in this case i have 4 different year field and different Month field ,

I just want 1 common year field and 1 common Month field .

For that i have tried to make link table for SIte, SubSegment,Segment,Corporate table , but it is making circular reference .

Please help me !!!!

Thanks

12 Replies
avinashelite

in order to build a common year or month for all the tables you should have common key between all the tables or atleast you should have  a reference key which will help you to link all the tables. As per your inputs I am not able to see any common key to which is linking the tables. can you please share the same data so that we can analyse

avinashelite

c.png

SreeniJD
Specialist
Specialist

Hi Agnivesh,

Post sample data. In case you don't have common keys, I recommend to create some pseudo column by autonumber function and get the tables connected..

HTH

Sreeni

avinashelite

jaaldurgam‌ in this case we cannot assume the key rite? because how we will get to know which site is linked with which segment

SreeniJD
Specialist
Specialist

Avinash - We will get clarity if we have the data. I was giving generic answer to connect between tables...

Correct me If I'm wrong

Sreeni

avinashelite

your rite, let wait for the data

tamilarasu
Champion
Champion

Capture.PNG

agni_gold
Specialist III
Specialist III
Author

Hi Friend ,

Please see the sample attached data ,

Here for PLFact sheet ,

I am loading 4 times same PLFact  with different join condition ,

As per my data model i have shared earlier

We are making 4 Different chart to show the site wise , segment wise and sub segment wise and corporate wise.

agni_gold
Specialist III
Specialist III
Author

Hi Friend ,

Please see the sample attached data ,

Here for PLFact sheet ,

I am loading 4 times same PLFact  with different join condition ,

As per my data model i have shared earlier

We are making 4 Different chart to show the site wise , segment wise and sub segment wise and corporate wise.