Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

max date with 2 feilds

hi,

i have 2 feild with date, i want to calculte , the max date like this:

date = 03/01/2016

date1 = 28/12/2015

max_date=???

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 ?

thanks'

yarin.

1 Reply
Highlighted

Re: max date with 2 feilds

‌In the script, you can try something like this:

Date(RangeMax((date -7), date1)) as maxDate