Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

Highlighted

c.png

Highlighted
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

Highlighted

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

Highlighted
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

Highlighted

your rite, let wait for the data

Highlighted

Capture.PNG

Highlighted
Specialist III
Specialist III

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.

Highlighted
Specialist III
Specialist III

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.