topic Re: Calender date issue in QlikView

Calender date issue

Mon, 07 Apr 2014 08:53:28 GMT

Hi All,

I have two calenders, one for start date and one for end date.

I am getting one field from database named week_date.

For both start date and end date, i have given min and max conditions which are like :

min(week_date) and max(week_date).

I have one more requirement that end date should always be greater than start date.

Is there any solution to define min and max value for End date.

Thanks in Advance...!!!

Mon, 07 Apr 2014 09:08:49 GMT

Hi,

This means

Are you providing start date and end date for selecting the date range to the users?

If yes,

then you have to check for End date should be greater than the start date always in their selection

Mon, 07 Apr 2014 09:15:28 GMT

Yeah,we are providing start and end date selections to the user.

But we are not getting how to provide the min value in end date always greater than the start date.

I have tried with the below expression in min value of end date:

week_date > start date

But its not working.

Mon, 07 Apr 2014 09:25:53 GMT

can you provide sample app or data