Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Calendar not displaying end date selected

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

4 Replies
Not applicable

Re: Calendar not displaying end date selected

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

Not applicable

Re: Calendar not displaying end date selected

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

Hi,

     Use below expression to create Date.

    

    

Date

(floor([logdate])) as Log_Date_JD 

Regards,

Kaushik Solanki

Not applicable

Re: Calendar not displaying end date selected

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

Community Browser