topic Re: PREVIOUS MONTH DATA in QlikView

PREVIOUS MONTH DATA

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

Dear All

I using following formula to get a previous month data

=MonthEnd(max(MARKETING_DATE),-1)

But this formula get a result only last month i want to get a sales value using above formula. may data field name is GROSSTOT

please help

thanks

sagara

Re: PREVIOUS MONTH DATA

Vegar — Thu, 24 Oct 2019 05:39:51 GMT

Try this

Sum({<MARKETING_DATE = {">=$(=MonthStart(max(MARKETING_DATE),-1))<$(=MonthEnd(max(MARKETING_DATE),-1))"} >}GROSTOT)

Re: PREVIOUS MONTH DATA

Brett_Bleess — Mon, 04 Nov 2019 18:49:47 GMT

Sagara, did Vegar's post get things working as you wanted? If so, do not forget to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know it worked. If you are still working upon things, leave an update for us.

Regards,
Brett