Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
anindya_manna
Creator II
Creator II

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

3 Replies
Anonymous
Not applicable

Hi,

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

antoniotiman
Master III
Master III

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

RonaldDoes
Partner - Creator III
Partner - Creator III

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