Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

prma7799
Honored Contributor III

Link new table with existing data model

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

14 Replies
sasikanth_narne
Valued Contributor III

Re: Link new table with existing data model

hi,

i think you just need only target field,

Do a left join with Fact_GL_Entry based on Div_code

MVP
MVP

Re: Link new table with existing data model

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

prma7799
Honored Contributor III

Re: Link new table with existing data model

Hi Sunny ,

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

Thanks

prma7799
Honored Contributor III

Re: Link new table with existing data model

Hi Sunny K,

I tried it but not get expected output.

Thanks

prma7799
Honored Contributor III

Re: Link new table with existing data model

sunindia

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

My expected out is 835.58

Thanks

sathishkumar_go
Contributor III

Re: Link new table with existing data model

Hi,

I think target table is not linked properly.

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

-Sathish

prma7799
Honored Contributor III

Re: Link new table with existing data model

Hi Satish,

Thanks for your response.

I am linking via div_code...

Thanks

sathishkumar_go
Contributor III

Re: Link new table with existing data model

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

-Sathish

prma7799
Honored Contributor III

Re: Link new table with existing data model

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.

Community Browser