topic Calender Object in QlikView

Calender Object

Wed, 06 Oct 2010 08:43:40 GMT

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.

Calender Object

Wed, 06 Oct 2010 23:26:50 GMT

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

Calender Object

Thu, 07 Oct 2010 05:16:34 GMT

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.

Calender Object

Thu, 07 Oct 2010 05:54:12 GMT

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

Calender Object

Thu, 07 Oct 2010 09:13:50 GMT

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.

Calender Object

Thu, 07 Oct 2010 22:28:53 GMT

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

Calender Object

Fri, 08 Oct 2010 19:23:53 GMT

Thanks Rod ,

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

Calender Object

Sun, 17 Oct 2010 09:18:26 GMT

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

Calender Object

Sun, 17 Oct 2010 22:38:29 GMT

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

Calender Object

Thu, 21 Apr 2011 12:34:58 GMT

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

Calender Object

chris_johnson — Thu, 21 Apr 2011 13:50:08 GMT

Hi Lee,

Are you selecting one date in particular? I think when you are using $(CalendarStart) it will only evaluate if you only have one possible value, otherwise it won't know what to display.

Not sure if that's the issue, just thought I'd mention it.

Chris

Calender Object

Thu, 21 Apr 2011 13:57:16 GMT

Hi Chris,

I am just selecting the one day ... just to test if it is being passed to the variable and it is not ...

But thanks for the tip

Lee

Calender Object

chris_johnson — Thu, 21 Apr 2011 14:03:31 GMT

Hi,

Do you have a sample you could upload just so we could have a play with? These things catch me out sometimes too.

Chris

Calender Object

Thu, 21 Apr 2011 14:20:06 GMT

Sure ... attached is a simple example of what I am trying to do ...

Not using a variable ... works ... using one does not ...

Calender Object

chris_johnson — Thu, 21 Apr 2011 14:57:35 GMT

Hi,

I changed the variable in the text box from $(myCalendar) to just myCalendar and it now acts the same as the other text box.

I'm not sure about how you would make the text box so that you could input a range of dates though. The only time I've done this is using the Slider object and linking it to the calendar, which would work in your case but I'm not sure that's what you're after.

Sorry, my knowledge is a bit limited with this!

Oh, it looks like you can set the Calendar object to multi value in the properties which will then set a range on the Calendar table.

Chris

Calender Object

Thu, 21 Apr 2011 15:08:21 GMT

Hey ... thanks Chris ... I always thought you had to prefix variables with the $Expansion to return all values in the variable ...

Pleased that you solved it ... can crack on now.

Cheers

Lee