topic Re: table is not link properly in QlikView

table is not link properly

prma7799 — Thu, 24 Sep 2015 04:37:06 GMT

Hi All,

I have one table called fact_budget and I link it to link table but entire data will come but when i select year then data not associate with budget table.

I think i haven't done link properly can anyone help me out.

I want Fact_Budget table will associate with all entire data model.

Please help.

Thanks

Re: table is not link properly

parthakk — Thu, 24 Sep 2015 04:48:22 GMT

Hi,

Your master calendar and link table are connected using Posting date. But there is no association between posting date and %BudgetKey to link it to FACT_Budget.. So your selection is not associated with FACT_Budget table. If u can then add Posting date to key as well.

Thanks,

Partha K

Re: table is not link properly

krishna20 — Thu, 24 Sep 2015 04:48:48 GMT

Hi,

Try by creating Composite Keys.

Re: table is not link properly

robert_mika — Thu, 24 Sep 2015 04:52:33 GMT

Although they have the same name the combined fields are not the same so the new Key field has different values

LinkTable

AUTONUMBER(date([Posting Date],'DD/MM/YYYY') & '_' & BusSeg_Code & '_' & AccLoc_Code & '_' &Null()) AS %BudgetKey,

Fact_Budget

AUTONUMBER(date([Posting Date],'DD/MM/YYYY') & '_' & BusSeg_Code & '_' & AccLoc_Code & '_' & [Document No_]) AS %BudgetKey,

Re: table is not link properly

parthakk — Thu, 24 Sep 2015 04:52:55 GMT

Hi,

I could observe that your master calendar is not linked to FACT_GL_Entry or value_entry.. I doubt on the key formation and its respective association.

Thanks,

Partha K

Re: table is not link properly

prma7799 — Thu, 24 Sep 2015 05:08:42 GMT

Hi Robert / Pertha,

Thanks for quick response.

I have corrected that all you said and add one more fact_budget table into linktable tab but i am getting synthetic table and my budget table is directly link to master calendar.

PFA

Re: table is not link properly

parthakk — Thu, 24 Sep 2015 05:27:11 GMT

Hi,

My replies are getting moderated. If u can then can u share sample data of three tables? Your year is still not associated with FACT_GL_Entry,Value Entry and Budget. If u share sample data then can try it.

Thanks,

Partha K

Re: table is not link properly

prma7799 — Thu, 24 Sep 2015 05:50:15 GMT

Hi parthakk‌

PFA...

I am very thankful to you...

Re: table is not link properly

parthakk — Thu, 24 Sep 2015 06:06:24 GMT

Hi,

I guess by mistake you have given wrong fact_budget qvd. Its similar to that of FACT_GL_Entry.

Partha K