topic Re: Calendar in QlikView

Calendar

Anonymous — Tue, 25 Feb 2014 18:19:21 GMT

Hi,

I have a calendar. I selected some date, then use "clear all" to clear all selections. But calendar still shows my selected dates.

Is it possible to set up first and last date?

Thanks,

whiteline — Tue, 25 Feb 2014 18:43:21 GMT

Hi.

Do you mean calendar object (slider) ?

Anonymous — Tue, 25 Feb 2014 18:45:50 GMT

I guess it is about calendar objects based on variables.

Variables are not cleared as selections. You need actions that set one calendar (variable) to the min date, and another to max.

Anonymous — Tue, 25 Feb 2014 19:14:02 GMT

Hi again,

Please see my attached file.

I use variables, which select in field "oDate".

I used Actions -Clear All, set Variable. In calendar is empty space, but variable vStart shows the first date.

Thanks,

Anonymous — Tue, 25 Feb 2014 19:44:34 GMT

See attached

Your variable are numeric, not in a date format, so you have to keep them numeric in Actions as well, do not convert to date:

=min({1} date(oDate))

=max({1} date(oDate))

Anonymous — Tue, 25 Feb 2014 20:02:19 GMT

Thank you.