topic Re: Help to verify the script result If( Mod(Num(Month(AddMonths(MonthEnd(Today()), -1))),3) = 0, 1, in QlikView

Help to verify the script result If( Mod(Num(Month(AddMonths(MonthEnd(Today()), -1))),3) = 0, 1, 0)

Anonymous — Mon, 19 Nov 2018 08:14:09 GMT

Please kindly help me to verify the result of this script.

LET RunQuarterly = If( Mod(Num(Month(AddMonths(MonthEnd(Today()), -1))),3) = 0, 1, 0);

Thank you very much in advanced.

Re: Help to verify the script result If( Mod(Num(Month(AddMonths(MonthEnd(Today()), -1))),3) = 0, 1,

tresB — Mon, 19 Nov 2018 08:43:08 GMT

The code returns 1 if last month is a multiple of 3 else 0. However, the same can be achieved with a little simpler expression (removing few unnecessary functions), like:

LET RunQuarterly = If( Mod(Month(MonthEnd(Today(), -1)),3) = 0, 1, 0);

Re: Help to verify the script result If( Mod(Num(Month(AddMonths(MonthEnd(Today()), -1))),3) = 0, 1,

agni_gold — Mon, 19 Nov 2018 08:53:28 GMT

What exactly you want to do ?