Qlik Community

QlikView Documents

Documents for QlikView related information.

How to set Minimum and Maximum Date in calendar

techvarun
Valued Contributor II

How to set Minimum and Maximum Date in calendar

Find the lowest  and highest date from your data source

for example if you are using QVD as data source then use the below script to find the lowest and highest date value.

temp:

LOAD DateField

FROM your_QVD_Name.qvd (qvd);

MinMaxDate:

Load min(DateField) as MinDate,

        max(DateField) as MaxDate

    

        resident temp;

Drop Table temp;


for SQL Server Use this Query.

SELECT Min(DateField) as MinDate from Your_Table_Name

SELECT Max(DateField) as MaxDate from Your_Table_Name

then go to the calendar oblect and set the Limit as per the below pick

DateLimit.png

Now the user not able to select any date out of the range from data source

Labels (2)
Comments
carbal1952
Contributor II

The calendar from where the users select  the dates can be built  from the data as well.

See Qlikview Components from Rob Wunderlich (actually versión 8.1).

Thanks.

Version history
Revision #:
1 of 1
Last update:
‎2013-09-20 06:38 AM
Updated by: