topic Re: data modelling problem in QlikView

data modelling problem

munna1317 — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: data modelling problem

ecolomer — Fri, 05 Sep 2014 16:39:12 GMT

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

Re: data modelling problem

munna1317 — Fri, 05 Sep 2014 16:47:47 GMT

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

Re: data modelling problem

Fri, 05 Sep 2014 16:55:14 GMT

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

Re: data modelling problem

munna1317 — Fri, 05 Sep 2014 16:57:59 GMT

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

ashfaq_haseeb — Fri, 05 Sep 2014 17:00:02 GMT

Hi,

have a look at below post

data modelling problem

Regards

ASHFAQ

Re: data modelling problem

kumarkp412 — Fri, 05 Sep 2014 18:31:18 GMT

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 .