Calender Object

[#1]

Hi,

Would like to create the calender control independent of any coulmns in the database. Will use the calender object to select the date which will be passed as input. How to create the calender object independent of database columns.

[#2]

Hi XXX,

I think the easiest method is:

• create a variable
• create a calendar object
• link the calendar object to the variable

The variable will then hold the selcted date which can be passed through into function i.e. through use of set analysis.

I hope this helps.

Rod

[#3]

Hi Rod,

Thanks for the suggestion. I did the same thing. it is working fine. But the it has the year started with 2000 and End year as 2011 i.e it shows the 10 years. i tried to set the minimum and maximum values but still it is the same. Is it limitation it will be showing only the 10 years in the calender object.

[#4]

Hi XXX,

You need to enter the start and end values as numerics i.e 40458 instead of d/m/yyy type formats. You can also pass through the start and end values as variables i.e =$(Variable).

Either method will allow you to set a date range outside of the standard range.

Hope this helps.

Rod

[#5]

Thanks Rod . I have one more query on the calender object.i want the option of choosing the time as well in the calender object.

[#6]

Hi XXX,

The only way I know to set time is to create an additional slider object (linked to another variable) and set the minimum value as 0 and maximum value to 1 and then format the field as a time interval (h:mm).

From there you can combine the values in the two variables (date and time) and you should be able to get the result you are after.

Hope this helps.

Rod

[#7]

Thanks Rod ,

i think Qlikview should have a inbuilt calender control with time option so that we can use the calender control directly..................

[#8]

How link the calendar object to the variable ? Prompt in details, please

[#9]

Hi oleg_evt1970,

To create the variable, do the following:

• Select Settings > Variable Overview
• Click Add
• Enter a variable name i.e. myDate
• Click OK
• Click OK again

To add the variable to the Calendar object:

• On a sheet right click and select New Sheet Object > Slider/Calendar Object
• In the properties box set the Input Style to Calendar
• Check the radio button next to Variable(s)
• Select your variable name (i.e.myDate) from the list
• At this point you can continue configuring the calendar object or select OK

Now, after changing the date value you can select Settings > Variable Overview and see that your variable i.e. myDate has a value against it.

Hope this helps.

Rod

[#10]

Hi,

This is exactly what I am trying to do ... but getting a little stuck ... I have created a complete table of dates in the script under a table called Calendar and a field called Calendar. I have added a variable called CalendarStart ... this variable will be used to create a date range on a chart dimension ... e.g. Show me everything that started between 1st Jan and 1st Feb ...

I have linked the Calendar object and I have a list box of the table which has dates ... as a test I have a text box as =$(CalendarStart)

I can not seem to get any data into the variable CalendarStart ... apologies if this is really simple

Thanks

Lee