Need Help - Date Range Calclulation

Thu, 22 Dec 2016 12:54:48 GMT

hi All:

The existing questions in the forum got me this far (thanks to all previous posts), however I am stuck.

I have an existing calculating that gives me YTD Sales thru Current Week, I am trying to do same thing but for last year and I am striking out. See below.

Ray

// Trying to get sales thru current week for last year. I got it to work for current, but having issues for last

// These are my revised date statements and yield the dates I want

//addmonths(YearStart(Today()),-12)

//AddMonths(WeekEnd(Today()),-12)

//New Code for LAST YEAR

SUM({$<KEY_DATE = {'>=$(=addmonths(=YearStart(Today()),-12))<=$(=AddMonths(=WeekEnd(Today()),-12)}>}[Invoice Subtotal])

//ORIGINAL CODE FOR CURRENT YEAR

// SUM({$<KEY_DATE = {'>=$(=YearStart(Today()))<=$(=WeekEnd(Today()))'}>}[Invoice Subtotal])

Re: Need Help - Date Range Calclulation

sunny_talwar — Thu, 22 Dec 2016 16:37:25 GMT

May be this:

Sum({$<KEY_DATE = {'>=$(=YearStart(Today(), -1))<=$(=WeekEnd(AddYears(Today(), -1)))'}>}[Invoice Subtotal])

Sum({$<KEY_DATE = {'>=$(=YearStart(Today(), -1))<=$(=AddYears(WeekEnd(Today()), -1))'}>}[Invoice Subtotal])

topic Re: Need Help - Date Range Calclulation in QlikView

Need Help - Date Range Calclulation

Re: Need Help - Date Range Calclulation