Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
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
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