topic Re: Date range filter not including the last date on the selected range in QlikView

Date range filter not including the last date on the selected range

roebrich — Mon, 02 Oct 2017 18:47:57 GMT

Hello Experts,

My project is currently in the testing phase and the testers have raised a bug about our dashboard not showing the last date selected on the date range filter. I attached a sample file to help with the resolution of this. For example, select a date range of 8/21/2017 to 8/28/2017, you will notice on the table on the right that when you scroll to the bottom 8/28/2017 is not on the list. Change the date range to 8/21/2017 to 8/29/2017, now you will see records for 8/28/2017. The issue is not limited to those specific dates, it also happens on other dates.

Thank you so much in advance.

Re: Date range filter not including the last date on the selected range

sunny_talwar — Mon, 02 Oct 2017 18:52:52 GMT

The problem is that you date is a timestamp and I am guessing when you select 8/29/2017, it is the beginning of the day, i.e., 8/29/2017 00:00:00 instead of 8:29:2017 23:59:59.... so anything you have on 8:29:2017 is not getting selected.... may be create a new field in the script where you truncate the time portion using Floor() function

Floor([Opening At]) as [Floored Opening At]

Re: Date range filter not including the last date on the selected range

sunny_talwar — Mon, 02 Oct 2017 18:56:21 GMT

Check the attached

Re: Date range filter not including the last date on the selected range

roebrich — Mon, 02 Oct 2017 21:26:05 GMT

Thank you so much. I applied the new field only on the date range slider but kept the timestamp on the table. So far looks like it is working.