Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calendar object is not working

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..:)

5 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

Look at this attach.

Hope this helps...

Not applicable
Author

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

Not applicable
Author

Convert the field in load script