Calendar Object From and To

[#1]

Hi,

I have built a qlikview document and one of the features is a calendar object that shows the from and to date, from the field logdate.  However there are two issues with this.

1) The Calendar Objects only show January, February, March and April, but should show every month.

2) If you run the calendar to go from 01/01/2013 to 01/02/2013, the data brough back is not inclusive of the dates you have selected.  Therefore what comes back are log dates from the 02/01/2013 to the 31/01/2013.

Please see attached a copy of the Qlikview file.

Regards,

Jon Ditchfield

[Gysbert_Wassenaar · Accepted solution]

1) If you select 2013 you will see only January to April as there isn't data for the other months in 2013. If you select another year you can choose any month.

2) Your logdate field is a timestamp, not a date. That's why the selections are off. All logdates on 01/02/2013 have a time and are therefore larger than 01/02/2013 00:00:00. There isn't any data for 01/01/2013 so the selection seems to start at 02/01/2013.

[#3]

Thanks for your help Gysbert.  Its a a bit foolish of me not to spot the first issue .  However I will change my timestamp format into a date and use that.  Thanks for the help.