topic Re: Max sales date from March in QlikView

Max sales date from March

Sun, 11 May 2014 16:04:31 GMT

Hi,

I'm desperately trying to catch last sales date from two months back. Since it's May now, I shoud find last date from March. This is how I tried to do that:

sum(Month(AddMonths(Date(Today()),-2)), 'M/D/YYYY'), {<[Snapshot Date] = date(max({1}[Snapshot Date])},Year = {$(=only(Year))} )

Re: Max sales date from March

maxgro — Sun, 11 May 2014 18:06:25 GMT

not sure to understand as you have 3 field, year, month and snapshot date and I don't know the meaning;

if d is the date field, m the month field and y the year field

the max date of two months ago maybe

=max ({$<m={"$(=month(addmonths(Today(),-2)))"},y={"$(=year(addmonths(Today(),-2)))"}>} d)

Re: Max sales date from March

johnca — Sun, 11 May 2014 19:09:01 GMT

If I'm reading this right to get the last day of a month 2 months ago use...

Date(MonthEnd(Max(date),-2))

...with date being your date field. Just change the number to the number of months ago desired.