topic Re: set analysis to sum of sales of last 3 months. in QlikView

set analysis to sum of sales of last 3 months.

Tue, 27 May 2014 03:03:03 GMT

Hi,

i need to write a set analysis to calculate sales done in last 3 months.

For example....if the current selected month is Jan of year 2104 then the my formula should sum the sales done Oct, Nov and Dec of 2013...if the current selected month is Feb, 2014 then formula should sum the sales done in Nov 2013, Dec 2103 and Jan 2014.

Can you please me writing this expression?

Regards,

Saurabh

Re: set analysis to sum of sales of last 3 months.

Tue, 27 May 2014 04:12:25 GMT

Hi, Ramya

Its look like this:

=Sum({<Date={">=$(=MonthStart(AddMonths(Max(Date),-3)))<=$(=MonthEnd(AddMonths(Max(Date),-1)))"}>}Sales)

Change (-3) and (-1) to set your period

Re: set analysis to sum of sales of last 3 months.

jim_chan — Tue, 31 Jan 2017 20:52:52 GMT

Hi Alex,

can you tell me what is the -3 means and -1 means?