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: 
achraf
Contributor II
Contributor II

Multiple foreign keys between dimension table date and fact table

Multiple foreign keys between dimension table date and fact table

hi there,
i am a beginner in qlik sense, and i found a problem with association between dimension table date and fact table (MEL).

Annotation 2019-05-19 012402.png

could you explain the best way to resolve the problem.

Anyone please help.
Thanks,

https://imgur.com/apSalgI

Labels (2)
1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

Hi Achraf,

Then you need to go for the second option. Create two calendars one with the key ID_DimIssueDate and another calendar with the key ID_DimClosingDate. This way they can select from both.

Jordy

Climber

Work smarter, not harder

View solution in original post

4 Replies
JordyWegman
Partner - Master
Partner - Master

Hi Achraf,

What do you want to achieve? Do you want to see your data based on IssueDate? Then you can rename the ID_DimDate to ID_DimIssueDate. 

You can also create two calendars, one for IssueDate and one for ClosingDate. Though, this can make it harder for users to use.

Jordy

Climber

Work smarter, not harder
achraf
Contributor II
Contributor II
Author

I want to see data based on IssueDate and Closingat, where the user can choose both.
but i don't know how i can do it.
Thank tou sir
JordyWegman
Partner - Master
Partner - Master

Hi Achraf,

Then you need to go for the second option. Create two calendars one with the key ID_DimIssueDate and another calendar with the key ID_DimClosingDate. This way they can select from both.

Jordy

Climber

Work smarter, not harder
achraf
Contributor II
Contributor II
Author

Thank you sir, i will try this solution