topic dates are not linked!! in QlikView

dates are not linked!!

ali_hijazi — Thu, 26 May 2011 13:27:26 GMT

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

dates are not linked!!

Thu, 26 May 2011 13:40:39 GMT

Hi,
Do you really need Call Month? It should have the same value as month, so you can just use that instead?

/@Ungvall

dates are not linked!!

ali_hijazi — Thu, 26 May 2011 13:45:04 GMT

I need the calendar month which is named Month
the month selection is made on the left side of the sheet but since the link exists and actually data are not linked I'm getting no data on the charts

dates are not linked!!

Thu, 26 May 2011 13:50:03 GMT

Have you tried to use date# instead of just date?

/@Ungvall

dates are not linked!!

ali_hijazi — Thu, 26 May 2011 13:52:47 GMT

Yes and still there is not link !!

dates are not linked!!

Thu, 26 May 2011 13:57:40 GMT

What's the format of caDateTime?

/@Ungvall

dates are not linked!!

ali_hijazi — Thu, 26 May 2011 14:03:50 GMT

the data is coming from an Access database caDateTime is of type DateTime and here is a sample record data

07-Jan-05 1:53:48 PM

dates are not linked!!

ali_hijazi — Thu, 26 May 2011 14:09:27 GMT

when you preview the data in qlikview the data displayed is the same!!! just as the specified date format in the main tab

dates are not linked!!

Thu, 26 May 2011 14:33:47 GMT

Hi,
A solution could be to try text(date(caDateTime)) and see...

Another thought is - do you really need a master calendar? or can't you just use Date, Month, and Year created from caDateTime...

/@Ungvall

dates are not linked!!

ali_hijazi — Thu, 26 May 2011 14:42:01 GMT

ah You mean display the distinct month of caDateTime
well yes but this is a sample data and database will contain dates for several years so indeed I need a master calendar

dates are not linked!!

rwunderlich — Thu, 26 May 2011 15:06:26 GMT

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

dates are not linked!!

amien — Wed, 18 Apr 2012 23:02:30 GMT

Thanks again Rob