topic Dynamic date range for calender in QlikView https://community.qlik.com/t5/QlikView/Dynamic-date-range-for-calender/m-p/1341199#M413162 <HTML><HEAD></HEAD><BODY><P>Hi , </P><P></P><P>I have a calendar object , wherein , I have hard-coded:</P><P>min value as Num(Date#('01/01/2016', 'MM/DD/YYYY'))</P><P>max value as Num(today())</P><P></P><P>How can i make min value dynamic to always be 01/01/current year-1 , so in 2018 , it should be 01/01/2017</P><P></P><P>There is another requirement to have min value as :<SPAN style="font-size: 13.3333px;"> Num(Date#('01/01/2016', 'MM/DD/YYYY'))</SPAN></P><P>max value as 12/31/current-year-2, so in 2018 , max value will be 12/31/2016</P><P>How can max value be made dynamic?</P></BODY></HTML> Wed, 19 Apr 2017 10:16:59 GMT swati_rastogi27 2017-04-19T10:16:59Z Dynamic date range for calender https://community.qlik.com/t5/QlikView/Dynamic-date-range-for-calender/m-p/1341199#M413162 <HTML><HEAD></HEAD><BODY><P>Hi , </P><P></P><P>I have a calendar object , wherein , I have hard-coded:</P><P>min value as Num(Date#('01/01/2016', 'MM/DD/YYYY'))</P><P>max value as Num(today())</P><P></P><P>How can i make min value dynamic to always be 01/01/current year-1 , so in 2018 , it should be 01/01/2017</P><P></P><P>There is another requirement to have min value as :<SPAN style="font-size: 13.3333px;"> Num(Date#('01/01/2016', 'MM/DD/YYYY'))</SPAN></P><P>max value as 12/31/current-year-2, so in 2018 , max value will be 12/31/2016</P><P>How can max value be made dynamic?</P></BODY></HTML> Wed, 19 Apr 2017 10:16:59 GMT https://community.qlik.com/t5/QlikView/Dynamic-date-range-for-calender/m-p/1341199#M413162 swati_rastogi27 2017-04-19T10:16:59Z Re: Dynamic date range for calender https://community.qlik.com/t5/QlikView/Dynamic-date-range-for-calender/m-p/1341200#M413163 <HTML><HEAD></HEAD><BODY><P>Min date for previous year</P><P></P><P>=YearStart(Addyears(today(),-1))</P><P></P><P></P><P><SPAN style="font-size: 13.3333px;">Max date for previous year</SPAN></P><P> =YearEnd(Addyears(today(),-1))</P></BODY></HTML> Wed, 19 Apr 2017 13:15:42 GMT https://community.qlik.com/t5/QlikView/Dynamic-date-range-for-calender/m-p/1341200#M413163 vinieme12 2017-04-19T13:15:42Z