Discussion board where members can learn more about Qlik Sense App Development and Usage.
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,
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.
View solution in original post
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.