Solved: dates are not linked!! - Qlik Community

ali_hijazi · ‎2011-05-26

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

I can walk on water when it freezes

rwunderlich · ‎2011-05-26

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

View solution in original post

Report Inappropriate Content · ‎2011-05-26

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

/@Ungvall

ali_hijazi · ‎2011-05-26

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

I can walk on water when it freezes

Report Inappropriate Content · ‎2011-05-26

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

/@Ungvall

ali_hijazi · ‎2011-05-26

Yes and still there is not link !!

I can walk on water when it freezes

Report Inappropriate Content · ‎2011-05-26

What's the format of caDateTime?

/@Ungvall

ali_hijazi · ‎2011-05-26

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

I can walk on water when it freezes

ali_hijazi · ‎2011-05-26

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

I can walk on water when it freezes

Report Inappropriate Content · ‎2011-05-26

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

ali_hijazi · ‎2011-05-26

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

I can walk on water when it freezes