Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Formula for Previous Month Number

Hi,

I am trying to come up with a formula/function that returns a month number that is n months prior to a given month.

My function should have two arguments: monthnum and n

For example:

f(2,2)=12     -> the month two months before Feb. is Dec.

f(4,3)=1       -> the month three months before Apr.. is Jan.

Best,

R

1 Reply
MVP
MVP

Re: Formula for Previous Month Number

May be something like this:

Month(AddMonths(MakeDate(Year(Today(), Date#(Month, 'MMM')), -n))

Replace n with the number of months you wish to go back and Month with whichever month you plan to start with