Discussion Board for collaboration related to Creating Analytics for QlikView.
I have been struggling with this connecting my data and my calender for a few weeks now.
What makes the calender take only parts of the data instead of all of the dates?
What do I need to do in my script in order for these tables to align with each other?
The Calender object on the QVW below is associated with [Create Date]
[Create Date] is associated with the list of request numbers, names for that request, and another date.
If you choose a calender selection (2015), it will pull up dates associated, but will not find other information.
If you choose a Request ID, it will align with the user name and dates, but nothing on the calender object.
floor function remove the time part of the date and date function format the date
date(floor(date_time)) as DateWithoutTime
dat_data as date_time // dat_data is a datetime
Get the Dates Right
QlikView Date fields
View solution in original post
do you need the time in the create date?
the problem is the datetime ARRequestList and MasterCalendar doesn't match
why doesn't match?
because you calculate the min Create Date from ARRequestList 4/12/2006 7:02:55 AM
and generate the calendar from this, all days with the same time 7:02:55 but in your ARRequestList table the time is different and the association often doesn't work
I suggest to only use the date part in your Create Date (if possible with your requirement)
I do not need the time in create date.
I've been researching more on SQL server code and trying to figure out how to use only the date.
May I ask for an example or a function that could isolate the date regardless of time?
Thanks in advance!
Thanks! This did the trick!