Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
swati_rastogi27
Contributor

Dynamic date range for calender

Hi ,

I have a calendar object , wherein , I have hard-coded:

min value as Num(Date#('01/01/2016', 'MM/DD/YYYY'))

max value as Num(today())

How can i make min value dynamic to always be 01/01/current year-1 , so in 2018 , it should be 01/01/2017

There is another requirement to have min value as : Num(Date#('01/01/2016', 'MM/DD/YYYY'))

max value as 12/31/current-year-2, so in 2018 , max value will be 12/31/2016

How can max value be made dynamic?

Tags (1)
1 Reply
vinieme12
Esteemed Contributor II

Re: Dynamic date range for calender

Min date for previous year

=YearStart(Addyears(today(),-1))

Max date for previous year

=YearEnd(Addyears(today(),-1))