Discussion Board for collaboration related to QlikView App Development.
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?
Min date for previous year
Max date for previous year