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: 
Not applicable

Data model calendar

Hello,

I have 3 tables.

Defect: DetectedDate, ClosedDate

Request: RequestID, OpenDate, ClosedDate

TimeLog: RequestID, LogDate

I want to use a master calendar to persist date selections in my reports using Defect.DetectedDate, Request.ClosedDate, and TimeLog.LogDate.

The issue is that I also want Request.RequestID to join with TimeLog.RequestID.  How can I achieve both?

Thank you

1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can't do both. I think you should create more calendars. See this discussion for more information. You could use a calendar data island if you want to select one date and find the matching records with that date in all your date fields. See this tutorial

edit: You can concatenate the fields for your key first and apply autonumber to that:

autonumber(ProjectName & DefectID) as MyKey


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

You can't do both. I think you should create more calendars. See this discussion for more information. You could use a calendar data island if you want to select one date and find the matching records with that date in all your date fields. See this tutorial

edit: You can concatenate the fields for your key first and apply autonumber to that:

autonumber(ProjectName & DefectID) as MyKey


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you, that's guiding me down the right path.

Any idea how to generate autonumbers?  My defect table has a compound key (ProjectName + DefectID = Primary Key).  I'd rather convert the two fields to an integer rather than concatenate the two fields.

Thank you