topic Re: Flag for Next Month/Year in QlikView

Flag for Next Month/Year

stuwannop — Mon, 23 Dec 2013 10:05:44 GMT

Hi Everyone

I have a script line that will return a 1 or a 0 based on the date falling in the next month. The problem I have is when it gets to December, where the script below will return the year 2013 for todays date, not 2014.

I can see why it does it but I was wondering how I could get around it - I was thinking of putting in an IF statement (where if the month is 12 then +1 to the year) - but is there a smarter way of doing it? Thanks for any help!

( Month(Addmonths(Today(),1)) =Month([Promised Payment Date]) AND Year(Today())= Year([Promised Payment Date]), 1, 0)

Re: Flag for Next Month/Year

Nicole-Smith — Mon, 23 Dec 2013 15:46:51 GMT

if(InMonth([Promised Payment Date], today(), 1), 1, 0)

This says if [Promised Payment Date] is in the month after today (denoted by the 1).

Re: Flag for Next Month/Year

Mon, 23 Dec 2013 16:40:27 GMT

Just changed your Year condition to have greater than or equal to and added add months

= if(Month(Addmonths(Today(),1)) = Month(date('01/23/2014','MM/DD/YYYY')) AND Year(Addmonths(Today(),1)) >= Year(date('01/23/2014','MM/DD/YYYY')),1, 0)

Re: Flag for Next Month/Year

iktrayanov — Mon, 23 Dec 2013 19:38:54 GMT

try

=If (fabs(Month([Promised Payment Date]) - Month(Today())) =1, 1,0)

Re: Flag for Next Month/Year

Mon, 23 Dec 2013 19:57:58 GMT

Please try with MonthStart or InMonth functions like below:

Method 1: MonthStart

Let vDateCheck = Num(MonthStart(AddMonths(Today(),1))) ;

IF(MonthStart([Promised Payment Date]) = $(vDateCheck) , 1, 0) AS NextMonthYr_Flag

Method 2: InMonth

IF(InMonth([Promised Payment Date], Today() , 1) , 1, 0) AS NextMonthYr_Flag