topic Re: Values less than a date should not be selected in QlikView

Values less than a date should not be selected

Athira_K — Tue, 07 Dec 2021 13:43:32 GMT

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.

Re: Values less than a date should not be selected

Or — Tue, 07 Dec 2021 13:54:00 GMT

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

];

Re: Values less than a date should not be selected

Karlee — Thu, 09 Dec 2021 09:53:05 GMT

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