topic Re: Same date last year/quarter in QlikView

Same date last year/quarter

Fri, 14 Feb 2014 13:59:58 GMT

what expression would I use to find the same date, but last year or quarter? My best guess would be

Today()-quarter

Today()-year

Re: Same date last year/quarter

Michiel_QV_Fan — Fri, 14 Feb 2014 14:09:38 GMT

addyears(today(), -1) will give you the previous year date

addyear(today(), -1, ceil(month(today()/3) will give you year and quarter

Re: Same date last year/quarter

Fri, 14 Feb 2014 14:13:16 GMT

thanks Michiel

how about just last quarter though, instead of last quarter and year?

Re: Same date last year/quarter

Michiel_QV_Fan — Fri, 14 Feb 2014 14:16:31 GMT

ceil(num(month(addyears(today(), -1))/3) as Quater_lastYear

Re: Same date last year/quarter

Fri, 14 Feb 2014 15:35:21 GMT

So currently I have a line in my master calendar which flags if a date is in the last quarter to date.

inquartertodate (Feedback.TempDate,'2013-11-14',0) *-1 as Feedback.LQTDFlag

Obviously the problem with this is that I have to change the date manually each day. I tried insert your suggestion in place of '2013-11-14' (as per below) but i got an error

inquartertodate (Feedback.TempDate,ceil(num(month(addyears(today(), -1))/3),0) *-1 as Feedback.LQTDFlag

what am I doing wrong?

Re: Same date last year/quarter

Michiel_QV_Fan — Mon, 17 Feb 2014 09:57:29 GMT

You have a calculated quarter in the basedate. This should be a date.

Try this:

inquartertodate (Feedback.TempDate,today(),0) *-1 as Feedback.LQTDFlag

Re: Same date last year/quarter

Mon, 17 Feb 2014 10:04:34 GMT

That gives me the current quarter to date unfortunately. I actually need the last quarter to date

Re: Same date last year/quarter

Michiel_QV_Fan — Mon, 17 Feb 2014 11:36:16 GMT

inquartertodate (Feedback.TempDate,addmonths(today(), -3),0) *-1 as Feedback.LQTDFlag

Re: Same date last year/quarter

Mon, 17 Feb 2014 11:41:20 GMT

PERFECT! thanks