topic Re: Data model calendar in QlikView

Data model calendar

Mon, 01 Apr 2013 14:28:21 GMT

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

Re: Data model calendar

Gysbert_Wassenaar — Mon, 01 Apr 2013 15:05:59 GMT

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

Re: Data model calendar

Mon, 01 Apr 2013 15:24:45 GMT

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