topic Re: Calendar object is not working in QlikView

Calendar object is not working

Tue, 04 Feb 2014 11:33:31 GMT

Hi All,

I have created calendar object with start date & end date defined with variables(Start Date &End Date(Min& Max Dates) When user selects the Start date and End date is same day or day in calendar object(Ex: Start Date 10/4/2012,End Date:10/4/2012 ) it is not working properly,Start Date is working fine, End Date is displaying the garbage value instead of end date.

Thanks for your help in advance!

Chintala..:)

Re: Calendar object is not working

Anonymous — Tue, 04 Feb 2014 11:36:33 GMT

Can you post a example app, so that we can look into the real scenario!!!!!

Re: Calendar object is not working

Wed, 05 Feb 2014 11:46:40 GMT

Hi Gupta

let me explain..

1) I have created the calendar object with from Date and ToDate with 2 Variables(like VstartDate &VEndDate)

2) In calendar Properties have assigned the variables for VstartDate given the range min,Max values like( min({1}) fieldname(transdate),max({1} fieldname(transdate)) .

3) Same as above step for VEndDate given the min value(VstartDate),max({1} fieldname(transdate))

4) in triggers tab actions properties has been set.

Re: Re: Calendar object is not working

Wed, 05 Feb 2014 11:49:11 GMT

Look at this attach.

Hope this helps...

Re: Calendar object is not working

Wed, 05 Feb 2014 13:54:54 GMT

In DB particular field(i'e transdate)it is in form of timestamp But, when v load QVD, we took the fieldd in Mddyyyy format..and we are using it in From and To date

Re: Calendar object is not working

Wed, 05 Feb 2014 14:22:01 GMT

Convert the field in load script