Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master 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
Master
Master

hi,

i think you just need only target field,

Do a left join with Fact_GL_Entry based on Div_code

sunny_talwar

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

prma7799
Master III
Master III
Author

Hi Sunny ,

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

Thanks

prma7799
Master III
Master III
Author

Hi Sunny K,

I tried it but not get expected output.

Thanks

prma7799
Master III
Master III
Author

sunindia

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

My expected out is 835.58

Thanks

sathishkumar_go
Partner - Specialist
Partner - Specialist

Hi,

I think target table is not linked properly.

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

-Sathish

prma7799
Master III
Master III
Author

Hi Satish,

Thanks for your response.

I am linking via div_code...

Thanks

sathishkumar_go
Partner - Specialist
Partner - Specialist

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

-Sathish

prma7799
Master III
Master III
Author

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.