topic Re: Last year same month variables in QlikView

Last year same month variables

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

Hi,

We are having the below variables

let vMonthstart = date(MonthStart(today()-1),'1YYMMDD'); = 1161001

Let VLastMonthStart= date(monthStart(AddYears((today()-1),-1)),'1YYMMDD') ;=1150101

Here we required an variable which will give same month of last year like ,

VLastMonthStart = 1151001

Thanks..

Re: Last year same month variables

t_moutault — Fri, 28 Oct 2016 09:26:00 GMT

Hi,

Let VLastMonthStart= date(monthStart(AddYears((today()-1),-1)),'1YYMMDD') ;

works fine, give me 1151001

Re: Last year same month variables

sunny_talwar — Fri, 28 Oct 2016 09:59:18 GMT

May be you need this YearStart instead of AddYears because AddYears will just add one year to today's date, whereas YearStart will take you to the beginning of the year

=Date(MonthStart(YearStart((Today()-1),-1)),'1YYMMDD')

Re: Last year same month variables

sunny_talwar — Fri, 28 Oct 2016 10:00:35 GMT

My bad, you do need the same month of last year? If that is the case than what you have is already seems to be working (like Thomas mentioned above)