topic Re: Flagging all dates next month in QlikView

Flagging all dates next month

stuwannop — Thu, 04 Jul 2013 10:29:18 GMT

H All

I currently have a master calendar where I can calculate various flags on the dates based Financial Year to date, dates to month end etc etc. For example this formula gives me all dates in this month:

IF(InMonthtoDate(Date,MonthEnd(today()),0),1,0)

What I am trying to do now is flag all the dates NEXT month, so at the time of this post (July) all dates in August 2013 will be flagged.

Can anyone help?

Thanks in advance

Stu

Re: Flagging all dates next month

tresB — Thu, 04 Jul 2013 10:37:36 GMT

Something like this?

If( Month(Addmonths(Today(),1)) =Month(Date), 1, 0) as Flag

Re: Flagging all dates next month

stuwannop — Thu, 04 Jul 2013 10:51:21 GMT

Thanks Tresesco it's almost there but it's returning all August dates regardless of the year and I only need 2013. I've tried a few other things but I can't get it to work at the mo.

Stu

Re: Flagging all dates next month

tresB — Thu, 04 Jul 2013 10:53:12 GMT

So try :

If( Month(Addmonths(Today(),1)) =Month(Date) AND Year(Today())= Year(Date), 1, 0) as Flag

Re: Flagging all dates next month

stuwannop — Thu, 04 Jul 2013 10:57:12 GMT

Marvellous - I was almost there but that works perfectly - thanks very much for your help.

Stu