Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Do you really need Call Month? It should have the same value as month, so you can just use that instead?
/@Ungvall
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?
/@Ungvall
Yes and still there is not link !!
What's the format of caDateTime?
/@Ungvall
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...
/@Ungvall
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