Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
(which is 39800 or so) and your maximum=Date('01/01/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.=Date('31/12/2010')
Hope that helps.
And now how can i do to use the variable associated to slider/calendar object.
Thanks
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
Thanks you Miguel...