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: 
smilingjohn
Specialist
Specialist

Connection Problem

Hi All, 

I have a fact table (Date table ) which has 3 date fileds in it , "IssueDate", "DeliverdDate" and "ClosedDate". 

As per the requirement I have created the date table so that missing dates get populated . 

But in the data model i am having loop . Ecery table has to be connected the way it is but the looing should be avoided .

Can anyone please correct this connection. 

 

Thanks in Advance

5 Replies
smilingjohn
Specialist
Specialist
Author

Hi Community Any Adice on the above post ?

Thanks

smilingjohn
Specialist
Specialist
Author

Hi expertise,

Any solution on the problem stated in the above post .

Is there way to come up linking table ? 

smilingjohn
Specialist
Specialist
Author

Hi Community is this not possbi?

Brett_Bleess
Former Employee
Former Employee

Please review the following Design Blog posts:

https://community.qlik.com/t5/Qlik-Design-Blog/Circular-References/ba-p/1469332

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
mark_costa
Partner - Creator II
Partner - Creator II

Hi,

We just released a new video in our YouTube channel related to your question.
I hope it helps!

IPC Tips - Removing Circular References
https://youtu.be/s-QA8fbQDC4

 

Regards,

Mark Costa

Get hooked on Qlik at qlikbait.net