Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

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

Hi,

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

Untitled.png  

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.

Untitled.png  

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

Tags (2)
3 Replies
vb_qv_11
New Contributor III

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

Hi,

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

antoniotiman
Honored Contributor III

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

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

Partner
Partner

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

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.

Naamloos.png

Please find an example attached.

With kind regards,

Ronald