topic Re: How to make To date always greater than from date in calendar object? in QlikView

How to make To date always greater than from date in calendar object?

anindya_manna — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have to calendar object from date and to date to select arbitrary date range like below.

i want to input any date range in from date but for to date i want to only input the dates which is greater than from date.

I have call_date column.I used two variables V_start_date=min(call_date) and V_end_date=max(call_date).

properties of calendar object like below.

same for to date.

For setting min value and max value in to date i want like below

min value=V_start_date

max value>=V_start_date

Anonymous — Thu, 01 Jun 2017 12:34:14 GMT

Hi,

I have the same question and the same setup as detailed by Anindya - can anyone out there help??

antoniotiman — Thu, 01 Jun 2017 12:39:06 GMT

In second List MinValue -> Min(call_date) without {1}

RonaldDoes — Thu, 01 Jun 2017 12:42:17 GMT

Hi Anindya, V,

If, for the End Date calendar object, you input

=$(vStartDate)

you will not be able to choose an end date earlier than the start date.

Please find an example attached.

With kind regards,

Ronald