topic Re: Calendar object in QlikView

Calendar object

Thu, 14 Nov 2013 12:12:55 GMT

Hi,

I have two calendar objects: StartDate and EndDate. I used the variables vStartDate and vEndDate. starttime is my date field, since it has time also am using date(starttime) to get the date alone.

In the calendar object -> properties -> General for variable vStartDate i gave min value as "=date(min(starttime))" and max value as"Date(Max(starttime))" , for vEndDate also gave the same.

And a button for selection, action->'select in field' , in the field name i gave starttime and in the search string i gave " ='>='&Date(vStartDate,'M/D/YYYY')&'<='& Date(vEndDate,'M/D/YYYY')"

by giving this my table containing the date field should change but its not.

please correct me if i done wrong.

Thanks

Re: Calendar object

Thu, 14 Nov 2013 13:07:15 GMT

Does the field in which you want to perform the selection have the same date format 'M/D/YYYY'?
Also the example qwv would be helpful.

Re: Calendar object

Thu, 14 Nov 2013 13:09:47 GMT

Yes its like 6/29/2006

Re: Calendar object

Thu, 14 Nov 2013 13:12:14 GMT

Hi,

Can you please attach sample file regarding this issue.

Regards,

Ashutosh

Re: Calendar object

saumyashah90 — Thu, 14 Nov 2013 13:12:54 GMT

Try this
Date($(vStartDate),'MM/DD/YYYY')

Re: Calendar object

Thu, 14 Nov 2013 13:16:48 GMT

Hire is the sample, hope that will help.

Re: Calendar object

Thu, 14 Nov 2013 13:27:00 GMT

hi,

First clear one thing. do you want to add date into your date field which is selected in calender object or you want to only select in list box these selected dates??

Thanks,

Ashutosh

Re: Calendar object

christian77 — Thu, 14 Nov 2013 13:32:00 GMT

Hi.

You may want to use a slide or the calendar with multiple value.

Formats are important in calendars. Correct the format in the number tab.

Also, if you say vStartTime = min(Date), when you filter a date, the calendar will show only one date. You may want to say vStartDay = max({1}Date), that way it'll take the whole QlikView data base.

You can asign a format for that field for the whole document in the doc properties, number tab. Formats can be copied and paste to avoid misformats.

Re: Calendar object

Thu, 14 Nov 2013 13:35:01 GMT

I am not the one who have problem. I posted a working example for Remya.

Re: Calendar object

christian77 — Thu, 14 Nov 2013 13:41:57 GMT

Yeap.

All postings go to all participants, I believe. If you see my first post is in response to the person who started the question, that is Remya.

Salutes Alex.

Re: Calendar object

Sat, 16 Nov 2013 04:22:27 GMT

Hi,

Actually my date field 'starttime' is "6/28/2006 12:10:14 AM" like this, i use date(starttime) for getting the date for my table. If i select a date from the list box, table values are changing according to the date. But if i select from calendar object nothing changes in the table as well as list box.