topic Re: Last year sameday in QlikView

Last year sameday

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

Hi ,

We need to copmare last year same day sales like..

Yesterday = 6/9/2016 = Thrusday (2nd week)

Last year sameday = 6/11/2015 = Thrusday (2nd Week)

Thanks..

MK_QSL — Fri, 10 Jun 2016 11:53:53 GMT

You can simply subtract 52 * 7 = 364.

So,

Date(Date#('6/9/2016','M/D/YYYY')-364) as YourRequiredField

Date(Date#(YourDateField,'M/D/YYYY')-364) as YourRequiredField

Anonymous — Fri, 10 Jun 2016 12:03:54 GMT

Hi nareshthavidishetty,

Use function AddMonths:

Addmonths('6/9/2016',-12)='6/9/2015'

Regards!!