topic Re: Set Analysis Prior Month in QlikView

Set Analysis Prior Month

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

Dear All

I want to get prior month max date using input box and i already use following expression

=date(AddMonths(max(MARKETING_DATE),-1))

then i select apr 2019 and come to result 30 mar 2019 but it should be 31 mar2019

please help

sagara

Re: Set Analysis Prior Month

tresB — Fri, 14 Jun 2019 09:33:15 GMT

Try this:

=MonthEnd(max(MARKETING_DATE),-1)

Re: Set Analysis Prior Month

sagaraperera — Fri, 14 Jun 2019 09:51:14 GMT

Dear tresesco

Thanks Dear its work

sagara

Re: Set Analysis Prior Month

tresB — Fri, 14 Jun 2019 09:55:15 GMT

Sagara,
If you get your question answered, please mark it as correct/answered and 'like' it to close the thread. This will help other community members.