Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select Date Range in Calendar

Dear all,

I try to select Date Range by using calendar object. but it doesn't seem to be working.  could anyone tell me whether if the attached .qvw missing anything in variable setting, calendar value setting or other thing.  Thanks a lot

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

Hi,

Check the Attachment. You should give the 'Search String' in Select Field Like the Below

=if(vInvDate='DateRange',

'>='&Date($(vStartDate))&'<='&Date($(vEndDate)),Date($(vStartDate)))

and did small changes in the Button Actions.

View solution in original post

6 Replies
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

For ref.

PFA... !

Anonymous
Not applicable
Author

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Check Document setting >> Triggers>>Variable event triggers>>on change.

-Nagarjuna

settu_periasamy
Master III
Master III

Hi,

Check the Attachment. You should give the 'Search String' in Select Field Like the Below

=if(vInvDate='DateRange',

'>='&Date($(vStartDate))&'<='&Date($(vEndDate)),Date($(vStartDate)))

and did small changes in the Button Actions.

Anonymous
Not applicable
Author

Hi,

To make the date to get selected, need to create two more variables and in that convert the numeric format of date to date format and use that variable in button trigger.

Please find the attachment with the changes.

Not applicable
Author

It works fine to me. that's great.  Thanks a lot for your suggestion!!