Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

munna1317
Contributor II

data modelling problem

hi ,

as shown in the below image ,

i have one task details as " transaction table (Fact-Table)"

and

i have remain all are "master- table(Dimension-table)"

- Calender2 is a master caleder is just link to fact table with "link- date ".

1st problem :

i am getting only the transaction table details which are common to corresponding dimensions.

2nd problem :

i need to link master calender"linkdate" to all dimension with out generating any syntactic keys or circular reference .

plz tell solution ,

thnks in adv,

harish

ScreenHunter_25 Aug. 24 23.24 - Copy.jpg

Tags (2)
Labels (2)
6 Replies
ecolomer
Honored Contributor II

Re: data modelling problem

Can you revise your information because you speak about fields non exist in the graphic

munna1317
Contributor II

Re: data modelling problem

hi ,

Plz check the details

Task_details is transaction table(facttable)

remin all dimesion tabls


And Link date is an dimension that is connected to Task_details


thxs ,


harish


Not applicable

Re: data modelling problem

If you need to connect your Date Dimension (Master Calendar), you are going to have to use a Link Table.

munna1317
Contributor II

Re: data modelling problem

ya thxs robert ,

plz tell how to create a link table for above image just give sample sytax and model

regrds,

Harish

Re: data modelling problem

Hi,

have a look at below post

data modelling problem

Regards

ASHFAQ

kumarkp412
Contributor II

Re: data modelling problem

hi,

By using the link table, we can acess the master calendar.To create the link table

eg:

I cant understand the ur model,

I can not see in your sample if you have the field name in two tabels. If you dont you can not use it in your Linktable

link table:

load distinct

key(ie.common key between two tables)

resident calendar2;

concatenate

load distinct

key(ie.common key between two tables)

resident calendar1;

and if u want to remove the synthatic keys &circular referrence ,by renameing the feilds .

Community Browser