Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

theresaa
New Contributor III

Question on Calendar Object in QlikView

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?

calendarobject.png

Tags (1)
1 Solution

Accepted Solutions

Re: Question on Calendar Object in QlikView

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.

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
6 Replies
mwoolf
Honored Contributor II

Re: Question on Calendar Object in QlikView

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

theresaa
New Contributor III

Re: Question on Calendar Object in QlikView

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

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.

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
theresaa
New Contributor III

Re: Question on Calendar Object in QlikView

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
theresaa
New Contributor III

Re: Question on Calendar Object in QlikView

So - here is the variables defined in the script:

Variables_in_script.png

Here is Calendar object (min and max are Calendar_object.pngof 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:

3datesavailable.png

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

alldatesavailable.png

Thanks in advance for your help.