Discussion Board for collaboration related to QlikView Deployment.
as shown in the below image ,
i have one task details as " transaction table (Fact-Table)"
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,
Can you revise your information because you speak about fields non exist in the graphic
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
If you need to connect your Date Dimension (Master Calendar), you are going to have to use a Link Table.
ya thxs robert ,
plz tell how to create a link table for above image just give sample sytax and model
have a look at below post
data modelling problem
By using the link table, we can acess the master calendar.To create the link table
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
key(ie.common key between two tables)
and if u want to remove the synthatic keys &circular referrence ,by renameing the feilds .