Discussion board where members can get started with QlikView.
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
Go to 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.
Hi,Do you really need Call Month? It should have the same value as month, so you can just use that instead?
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
Have you tried to use date# instead of just date?
Yes and still there is not link !!
What's the format of caDateTime?
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
when you preview the data in qlikview the data displayed is the same!!! just as the specified date format in the main tab
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...
ah You mean display the distinct month of caDateTimewell yes but this is a sample data and database will contain dates for several years so indeed I need a master calendar