Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ali_hijazi
Honored Contributor

dates are not linked!!

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

1 Solution

Accepted Solutions

dates are not linked!!

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

11 Replies
Not applicable

dates are not linked!!

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
Honored Contributor

dates are not linked!!

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

Not applicable

dates are not linked!!

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

/@Ungvall

ali_hijazi
Honored Contributor

dates are not linked!!

Yes and still there is not link !!

Not applicable

dates are not linked!!

What's the format of caDateTime?

/@Ungvall

ali_hijazi
Honored Contributor

dates are not linked!!

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

ali_hijazi
Honored Contributor

dates are not linked!!

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

Not applicable

dates are not linked!!

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
Honored Contributor

dates are not linked!!

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

Community Browser