topic Re: Select Date Range in Calendar in QlikView

Select Date Range in Calendar

Mon, 30 Nov 2015 03:49:00 GMT

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

Re: Select Date Range in Calendar

nagarjuna_kotha — Mon, 30 Nov 2015 10:06:39 GMT

For ref.

PFA... !

Re: Select Date Range in Calendar

Anonymous — Mon, 30 Nov 2015 10:08:23 GMT

see this:

how to show the value "from date" to "to date"

Re: Select Date Range in Calendar

nagarjuna_kotha — Mon, 30 Nov 2015 10:08:52 GMT

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

-Nagarjuna

Re: Select Date Range in Calendar

settu_periasamy — Mon, 30 Nov 2015 10:33:00 GMT

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.

Re: Select Date Range in Calendar

Anonymous — Mon, 30 Nov 2015 10:59:58 GMT

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.

Re: Select Date Range in Calendar

Tue, 01 Dec 2015 03:17:09 GMT

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