Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
achraf
New 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

1 Solution

Accepted Solutions
Partner
Partner

Re: Multiple foreign keys between dimension table date and fact table

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
4 Replies
Partner
Partner

Re: Multiple foreign keys between dimension table date and fact table

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
New Contributor II

Re: Multiple foreign keys between dimension table date and fact table

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
Partner
Partner

Re: Multiple foreign keys between dimension table date and fact table

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
New Contributor II

Re: Multiple foreign keys between dimension table date and fact table

Thank you sir, i will try this solution