dates are not linked!!

[ali_hijazi]

HEllo

I've attached a qlikview document in which I created a master calendar and linked it to table from the database called calls

if you open each table you see that dates are in both tables and the link is made to the field DATE however if you open the tab "copy of control panel" you see how months are not linked

Please help

[rwunderlich · Accepted solution]

Your masterCalendar.Date and your calls.Date have different internal formats, so they will not link. masterCalendar.Date are integers, calls.Date have decimal (time values).

date() is a formatting function. It only affects the display value, not the internal vaue.

When you extract Date from caDateTime you should do it like this:

date(floor(caDateTime)) as [Date

That will extract the  integer (date) portion.

-Rob

http://robwunderlich.com

[amien]

Thanks again Rob