topic Re: Calendar not displaying end date selected in QlikView

Calendar not displaying end date selected

Mon, 15 Apr 2013 13:39:12 GMT

Hi,

I have a calendar object that shows the end date of a search criteria. However it doesn't display the date I have selected.

If my start date is 01/01/2012 and my end date is 01/02/2012, only up to the 31/01/2012 is brought back. The reason is because the field I am using is a TimeStap Format, therefore my date shows 01/02/2012 11:00:00, however it were 01/02/2012 00:00:00 it would show.

I have no idea how to amend my script so that it picks up the date regardless of the time stamp.

Please see attached a copy of the Qlikview File.

Regards,

Jon Ditchfield

Re: Calendar not displaying end date selected

Mon, 15 Apr 2013 16:41:48 GMT

Hi,

When you use the function 'Date' format without specifying the number, she picks up the operating system. Try to format the date as:

=Date((min({1}Log_Date_JD)),'DD/MM/YYYY')

Rebeca

Re: Calendar not displaying end date selected

Mon, 15 Apr 2013 20:16:48 GMT

Hi, Unfortunately this didnt work. I should have a date in the log date section of 09/02/2011, but it doesn't show even though I have added it in the end date section.

Re: Calendar not displaying end date selected

kaushiknsolanki — Tue, 16 Apr 2013 06:36:09 GMT

Hi,

Use below expression to create Date.

Date

(floor([logdate])) as Log_Date_JD

Regards,

Kaushik Solanki

Re: Calendar not displaying end date selected

Tue, 16 Apr 2013 10:14:50 GMT

Hi Kaushik,

I have tried adding the expression into my load script, which does pull through just the date, however I am still getting the issue where my calendar object is not pulling the required date.

E.G,

1) Set a date range from 01/01/2011 to 09/02/2011 - The last date that shows in the Straight Table is 24/01/2011

2) However if I set a date range from 01/01/2011 to 10/02/2011 - The last date that shows in the Straight Table is 09/02/2011.

The last date in the Straight Table that shows 09/02/2011 should show when I set my end date to 09/02/2011, but it doesnt.

Regards,

Jon Ditchfield