topic Re: Link new table with existing data model in QlikView

Link new table with existing data model

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

Hi All,

I have one application based on link table concept I want to add new table called "New Table"

I tried to add this table but I totally struct.

Please refer below post

How to link new excel file to existing data model

Thanks

Re: Link new table with existing data model

sasikanth — Tue, 09 Feb 2016 08:48:01 GMT

hi,

i think you just need only target field,

Do a left join with Fact_GL_Entry based on Div_code

Re: Link new table with existing data model

sunny_talwar — Tue, 09 Feb 2016 09:16:38 GMT

I don't see what the issue is? I see the table has been added already? Why do you think you are stuck?

Re: Link new table with existing data model

prma7799 — Tue, 09 Feb 2016 09:18:59 GMT

Hi Sunny ,

My problem is when I am select any MonthName then my target is not coming according to month.

Thanks

Re: Link new table with existing data model

prma7799 — Tue, 09 Feb 2016 09:19:55 GMT

Hi Sunny K,

I tried it but not get expected output.

Thanks

Re: Link new table with existing data model

prma7799 — Tue, 09 Feb 2016 09:31:22 GMT

sunindia‌

Please find the attached... I am got 49625.22 for the month of april.

My expected out is 835.58

Thanks

Re: Link new table with existing data model

sathishkumar_go — Tue, 09 Feb 2016 09:54:23 GMT

Hi,

I think target table is not linked properly.

How you are linking the Target table in to your existing data modelling?

-Sathish

Re: Link new table with existing data model

prma7799 — Tue, 09 Feb 2016 10:04:20 GMT

Hi Satish,

Thanks for your response.

I am linking via div_code...

Thanks

Re: Link new table with existing data model

sathishkumar_go — Tue, 09 Feb 2016 10:14:46 GMT

You have to use month or date also to link the target table

-Sathish

Re: Link new table with existing data model

prma7799 — Tue, 09 Feb 2016 11:02:14 GMT

Hi jagan‌ , tresesco‌ , sunindia‌, swuehl‌

I trying with below code PFA but when i select div_region and region and it will not associated with proper div_code.

Re: Link new table with existing data model

sathishkumar_go — Tue, 09 Feb 2016 11:39:47 GMT

Please check Division code 2050 is available in the Dim_DivisionMaster and Fact_GL_Entry.

-Sathish

Re: Link new table with existing data model

sathishkumar_go — Tue, 09 Feb 2016 11:44:56 GMT

Try this

Create a keyfield

Div_Code &'_'& date([Posting Date],'DD/MM/YYYY') as Key_Budget, in

FACT_GL_Entry table and

Targets:
LOAD Region,
Div_Code as Div_Code_Target,
MONTHSs,
Date,
Targets,
Div_Code &'_'& date(Date,'DD/MM/YYYY') as Key_Budget
FROM
[..\Qvds\NAVQVDS\Target.qvd]
(qvd);

-Sathish

Re: Link new table with existing data model

prma7799 — Wed, 10 Feb 2016 04:31:21 GMT

Hi Satish,

Your code is not working I have use below code to create key

Div_Code &'-'& num (month(([Posting Date]))) as TKye

when I select region America it should show me two div_code but when I select month april it display only one div_code against america.

see the attached ...

But when I select month nov then it will display proper two div_code against america...

Why this is happening can you please help me out.

Thanks

Re: Link new table with existing data model

jagan — Wed, 10 Feb 2016 04:50:41 GMT

Hi,

I think you can need to consider Month or Date field in addition to div_code as a key to join the tables.

Hope this helps you.

Regards,

jagan.

Re: Link new table with existing data model

sathishkumar_go — Wed, 10 Feb 2016 11:43:22 GMT

Did you checked Division code 2050 is available in the Dim_DivisionMaster and Fact_GL_Entry for the month Apr?

-Sathish