Issue with Date Format/Master Calendar

dcmcderm — Fri, 18 Apr 2014 18:21:47 GMT

I have implemented a single Master Calendar table with a Calendar Link table, since my data has multiple dates. I can't get the DATE key to properly join Master_Calendar and CalendarLink. For some date values it joins but the majority it does not. I have carefully formatted all dates the same way so I don't understand why it is not linking properly. If you look at my QVW file, I have a straight table that just subtracts one date from the other and even though they appear the same (for example, FIRST_REFERRAL_DATE and ADMIT_DATE both show as 12-04-2013) the comparison indicates they are in fact slightly different. In the source data these are in fact timestamps but I believe I have stripped off the time portion in my load script.

Anyway I am completely stuck - can anyone look at my QVW and offer advice?

Re: Issue with Date Format/Master Calendar

dcmcderm — Fri, 18 Apr 2014 18:28:10 GMT

I found the solution in this thread:

date() Function with Timestamp

It turns out date() doesn't actually strip the timestamp portion, it's just a display function. Must use floor(mytimestamp) to actually strip the time

topic Re: Issue with Date Format/Master Calendar in QlikView

Issue with Date Format/Master Calendar

Re: Issue with Date Format/Master Calendar