topic Re: Month Start ! in QlikView

Month Start !

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Team,

I am facing scenario as my script should run on:

Month start day ( eg 1st Aug)
Month start date should be week day (eg 'Mon''Tue''Wed''Thu''Fri') , if month 1 st day is 'Sat' or 'Sun' script should not run.
if month 1st day 'Sun' (Eg: 1 Aug) then script should run on next day (Eg : 2nd Aug Mon)

Will This Work:?

if match(Month Start(weekday(today()), 'Sun', 'Sat') )then

exit script;

end if

Script.

Please provide your Suggestion

Thanks in Advance!

Re: Month Start !

arvind_patil — Tue, 07 Aug 2018 09:55:15 GMT

Hi Ashok,

May be like below:

If( MonthStart(today())= today() and not Wildmatch(weekday(today()), 'Sun', 'Sat')

ExPression 1;

IF(Monthstart (Today()+1= Today() and wildmatch(weekday(today()-1),'Sun','Sat')

ExPression 1;

))

Thanks,

Arvind Patil

Re: Month Start !

Anonymous — Tue, 07 Aug 2018 10:00:42 GMT

Arvind thanks for your suggestion, Can u please elaborate this code!!

Re: Month Start !

tresB — Tue, 07 Aug 2018 10:08:18 GMT

Try like:

If NOT today()=LastWorkDate(MonthStart(Today()),1) Then

Exit Script;

End If

Edit: correction (highlighted) in function.

Re: Month Start !

Anonymous — Tue, 07 Aug 2018 10:47:48 GMT

Tresesco thanks for your suggestion, Can u please elaborate this code!!

Re: Month Start !

tresB — Tue, 07 Aug 2018 11:51:49 GMT

It is supposed to do what you wished it to do.

LastWorkDate with argument 1 - moves the date ahead if it falls in weekend. That way, you can handle the situation when a month start date falls in weekend and get the next working date, i.e a Monday like you wanted. Then we are comparing, if it is NOT today then we can safely exit the script. Or, you can remove the NOT and include the script under the conditioning, telling, the script would be executed only when today() is a month start excluding weekend.

Re: Month Start !

wilsonwebb — Tue, 07 Aug 2018 12:42:24 GMT

Hi Ashok,

My best advice to you would be to get a master calendar.

Re: Month Start !

Anonymous — Wed, 08 Aug 2018 13:17:23 GMT

Thanks for your explanation Tresesco!!