Calendar object date restriction

raju_salmon — Fri, 21 Jul 2017 02:14:46 GMT

Hi,

In one of my application i have created two calendar objects two select date range for user. These steps i have followed.

Create 4 variables: Date is the field in my app

vLimit1 - =Min(Num(Date))

vLimit2 = =Max(Num(Date))

vToDate = Null() - Changes based on user selection

vFromDate = Null() - Changes based on user selection

Created two calendar objects using vToDate and vFromDate variables with min and max values are vLimit1 and vLimit2.

Applied variable level triggers on vToDate and vFromDate with below expression on Date field (select in field)

='>='&Date(vToDate)&'<='&Date(vFromDate)

Now this is working absolutely fine, if i select date range from calendar objects then Date field getting selected. But however i cannot able to select out of the range (which i have already selected ) unless i clear the date field. This is may because of Min and Max date for vLimit1 and vLimit2 variables.

My problem is, can we select any date range without clearing the date filter? Please suggest.

Thanks a ton,

Raju.

Re: Calendar object date restriction

jonathandienst — Fri, 21 Jul 2017 05:25:46 GMT

Do you mean you want the limits to remain the same even after you've selected a date? Then

Set vLimit1 = =Min({1} Date);

Set vLimit2 = =Max({1} Date);

Num() is probably unnecessary here - it is a formatting function.

Re: Calendar object date restriction

arvind_patil — Fri, 21 Jul 2017 05:31:33 GMT

Hi Raju,

Please give sample Example of It. then it will understand more .

Thanks,

Arvind Patil

topic Re: Calendar object date restriction in QlikView

Calendar object date restriction

Re: Calendar object date restriction

Re: Calendar object date restriction