Max Date into the Expression

asknyldz — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I found max date in my data with this expression,

=max({<TYPE={'MACTUAL'}>}[MONTH])

The result is,

01/03/2016

Thats ok, but i want to set this formula in this expression, i don't want to write manually the date.

(sum({<TYPE={'ACTUAL'},BUSINESS={'NEW','EXPANDED'}*P([BUSINESS]),MONTH={'<=01/03/2016'}*P(MONTH)>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000

Regards,

Re: Max Date into the Expression

sunny_talwar — Fri, 22 Apr 2016 10:37:12 GMT

May be this:

(sum({<TYPE={'ACTUAL'},BUSINESS={'NEW','EXPANDED'}*P([BUSINESS]),MONTH={"<=$(=Max({<TYPE={'MACTUAL'}>}[MONTH]))"}*P(MONTH)>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000

topic Re: Max Date into the Expression in QlikView

Max Date into the Expression

Re: Max Date into the Expression