Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
f(2,2)=12 -> the month two months before Feb. is Dec.
f(4,3)=1 -> the month three months before Apr.. is Jan.
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