topic Same day last year problem in QlikView

Same day last year problem

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

Hi all,

I have a requirement wherein i got to get the sum of values starting from same day last year + 60 days in last year.

for example today is 06/09/2017 so i need to get sum(value) from 06/09/2016 till 09/07/2016.

Any help will be much appreciated.

Thanks in advance

Anupama Jagan

Re: Same day last year problem

hector_munoz — Fri, 09 Jun 2017 12:33:41 GMT

Hi Jagan

Try the following:

sum({< date_field={'<=$(#=vInitialDate)>=$(#=vFinalDate)'}>} sales)

, where:

vInitialDate = AddMonths(Today(), -12)

vFinalDate = AddMonths(Today(), -12) + 60

Regards,

Re: Same day last year problem

MK_QSL — Fri, 09 Jun 2017 12:43:11 GMT

=SUM({<DateFieldName = {'>=$(=AddYears(Today(),-1))<=$(=Date(AddYears(Today(),-1)+60))'}>}Sales)

Re: Same day last year problem

ahaahaaha — Fri, 09 Jun 2017 12:49:31 GMT

Hi,

Look attached file

Re: Same day last year problem

tajmohamed30 — Fri, 09 Jun 2017 15:47:57 GMT

you can try -60 from above examples

Re: Same day last year problem

richard_chilvers — Wed, 11 Sep 2019 13:46:41 GMT

...a word of caution - in my experience the AddYears and AddMonths functions often do not work effectively for leap years (ie. where 29th Feb is involved). I prefer to work out the same day last year using the same weekday and same week number from the previous year.