topic Re: Question on Calendar Object in QlikView in QlikView

Question on Calendar Object in QlikView

theresaa — Fri, 24 Mar 2017 19:26:00 GMT

I set a variable in my load script, one for starting calendar date, one for ending calendar date. I used those as the min and max values on the properties of the calendar object. The date that shows up in the object is correct (1/1/2017), but when I drop down the calendar icon to change it, I get only 2 years available (1990 and 1899) ??? Can anyone direct me to some examples or instructions on this issue?

Re: Question on Calendar Object in QlikView

m_woolf — Fri, 24 Mar 2017 19:58:19 GMT

Can you show how your variables are defined in the script (they look like text instead of dates)?

Re: Question on Calendar Object in QlikView

theresaa — Fri, 24 Mar 2017 20:11:51 GMT

let vDateFormat = 'MM/DD/YYYY';

let IRDATE2 = date(today()-1, '$(vDateFormat)');

let IRDATE1 = date(addmonths(today()-1, -1), '$(vDateFormat)');

Re: Question on Calendar Object in QlikView

Anil_Babu_Samineni — Sat, 25 Mar 2017 06:07:31 GMT

You may forget to add Min and Max options as below. Try to take variable name and then call Min Value as Start Date / End Date similar to Max Value. Then only calendar capture you have only these values to show case in UI.

Re: Question on Calendar Object in QlikView

theresaa — Mon, 27 Mar 2017 21:24:28 GMT

Thanks for all the help. Using Min Value and Max Value worked on getting the calendar object to display properly in the client. Still having trouble getting it to render properly in the Ajax Client. I'll keep trying! Thanks again.

Re: Question on Calendar Object in QlikView

Anil_Babu_Samineni — Tue, 28 Mar 2017 02:20:17 GMT

What was the issue on AJAX client? Can you show the image

Re: Question on Calendar Object in QlikView

theresaa — Tue, 28 Mar 2017 13:21:45 GMT

So - here is the variables defined in the script:

Here is Calendar object (min and max are of the dates from the data loaded into the app - not the variable)

When I first open the calendar object in Ajax, there are only 3 days available to select from:

If I hit CLEAR, then open it again, it has all kinds of dates available:

Thanks in advance for your help.