topic Re: Multiple foreign keys between dimension table date and fact table in App Development

Multiple foreign keys between dimension table date and fact table

achraf — Sat, 16 Nov 2024 20:50:23 GMT

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

could you explain the best way to resolve the problem.

Anyone please help.
Thanks,

https://imgur.com/apSalgI

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

JordyWegman — Mon, 20 May 2019 09:39:19 GMT

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

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

achraf — Mon, 20 May 2019 10:11:30 GMT

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

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

JordyWegman — Mon, 20 May 2019 11:01:36 GMT

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

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

achraf — Mon, 20 May 2019 11:19:59 GMT

Thank you sir, i will try this solution