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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Athira_K
Contributor III
Contributor III

Values less than a date should not be selected

Hello,
I have 2 calendar objects for 'from' and 'to'. I load my calendar  data from database. I dont want the user to select 'to' month less than 'from' month. Can we disable it or give some error pop up or is there any way to do that?

Example, From (has data from jan 2020 to dec 2021) and the user is selecting dec 2020. Now if user tries to give input less than dec 2020 in calendar object 'to'. It should throw error or it should not even allow user to give that.

2 Replies
Or
MVP
MVP

Create a calculation condition in your objects that checks if To >= From and if not, displays a message telling the user to change their selection.

Depending on how your calendar is set up, you might be able to force this at the app level by associating each From value with all To values equal to or greater than it, e.g. (simplistic example):

Load * INLINE [

From, To

202101, 202101

202101, 202102

202101, 202103

202102, 202102

202102, 202103

202103, 202103

];

Karlee
Contributor
Contributor

the date 2017-01-12 is translated to 2017-01-12 00:00:00

So a value like 2017-01-12 14:48:29 is greater than 2017-01-12 00:00:00.

If you want to match also this particular day you would have to use r.completed < '2017-01-13'

 

My CC Pay