topic Re. :Re: Re. :Re: Problem with Calendar Object in QlikView

Problem with Calendar Object

Wed, 25 Aug 2010 09:07:47 GMT

Hi community,

Please someone can explain me how to use the Calendar Object?

How to configure the Calendar Object to choose a good date?

Thanks in adavance

Problem with Calendar Object

Miguel_Angel_Baeyens — Wed, 25 Aug 2010 09:25:14 GMT

Hello Yimen,

When you draw a slider/calendar object, you have, basically two options. One is to show all possible values for a given date field already loaded. In this case no min or max values are allowed, the object takes the whole range of dates within that field.

The other is to set a variable which values will go from the mininum to the maximum value possible set in the properties of the object. Bear in mind that QlikView uses a special format then using dates, so your minimum value would be

=Date('01/01/2010')

(which is 39800 or so) and your maximum

=Date('31/12/2010')

In this case, when you select a date in the object, it is stored in the variable set, so you can use it further in your charts.

Hope that helps.

Re. :Re: Problem with Calendar Object

Wed, 25 Aug 2010 10:19:34 GMT

And now how can i do to use the variable associated to slider/calendar object.

Thanks

Re. :Re: Problem with Calendar Object

Miguel_Angel_Baeyens — Wed, 25 Aug 2010 10:34:27 GMT

Say that in your calendar you select the starting date for a calculation, and you store it in the variable vDate. Your chart then would look like

Sum({< Date = {">=$(=Date(vDate))"} >} Amount)

Or you may use it as a dimension

$(vDate)

It depends on what information do you want to get

Re. :Re: Re. :Re: Problem with Calendar Object

Wed, 25 Aug 2010 10:43:54 GMT

Thanks you Miguel...