Current Year and Previous Year Calculation in one Expression

Wed, 04 Dec 2013 21:18:22 GMT

Hi,

I want to calculate current year and previous year in one expression. Bascially:

if I have MonthYear as Sept 2013 then:

for Current year: it should start from July 2013-Sept 2013

for Previous year: it should start from July 2012-Sept 2012

I am using this formula it gives correct value for current year but for previous year it calculates the whole year (July 2012-June 2013). I want it to stop at Sept 2012.

=Sum({<CalMonthYear=,Date={">=$(=Date(Yearstart(Max(Date),-1,7),'MM/DD/YYYY'))<=$(=Max(Date))"}>}Cases)

Any help?

Thanks.

Re: Current Year and Previous Year Calculation in one Expression

MK_QSL — Wed, 04 Dec 2013 22:32:51 GMT

For Current Year

SUM({<MonthYear = {">=$(=Date(AddMonths(MonthYear,-2),'MMM YYYY')) <=$(=Date(MonthYear,'MMM YYYY'))"}>}SALE)

For Previous Year

SUM({<MonthYear = {">=$(=Date(AddMonths(AddYears(MonthYear,-1),-2),'MMM YYYY')) <=$(=Date(AddYears(MonthYear,-1),'MMM YYYY'))"}>}SALE)

Change appropriate field name as per your data model..

i.e. SALE to Cases, MonthYear to CalMonthYear

topic Current Year and Previous Year Calculation in one Expression in QlikView

Current Year and Previous Year Calculation in one Expression

Re: Current Year and Previous Year Calculation in one Expression