Discussion Board for collaboration related to QlikView App Development.
i have 2 feild with date, i want to calculte , the max date like this:
date = 03/01/2016
date1 = 28/12/2015
i want to show the max value beetwin 2 date feild but from feild "date" i need date-7
in the exm:
03/01/2016 - 7 =27/12/2015
so the maxdate feild need to show = 28/12/15
how to do it ?
In the script, you can try something like this:
Date(RangeMax((date -7), date1)) as maxDate