topic Date for occurrence in QlikView https://community.qlik.com/t5/QlikView/Date-for-occurrence/m-p/807701#M1043763 <HTML><HEAD></HEAD><BODY><P dir="ltr"><SPAN style="font-size: 15px; font-family: Arial; color: #000000;">Algorithm</SPAN></P><P><SPAN><BR /><SPAN style="font-size: 15px; font-family: Arial; color: #000000;">Hi,</SPAN><SPAN style="font-size: 15px; font-family: Arial; color: #000000;"><BR class="kix-line-break" /></SPAN><SPAN style="color: #000000; font-size: 15px; font-family: Arial;">I need to find a solution to calculate when activities occurs. I want to do this in the load script. As example an activity happens on Mondays and Thursdays every 5th week&nbsp; during 1.5 year.</SPAN></SPAN></P><P><SPAN style="font-size: 15px; color: #000000; font-family: Arial; line-height: 1.5em;">Thank's <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR />&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-size: 15px; font-family: Arial;"><BR /></SPAN></P></BODY></HTML> Mon, 24 Nov 2014 11:56:17 GMT 2014-11-24T11:56:17Z Date for occurrence https://community.qlik.com/t5/QlikView/Date-for-occurrence/m-p/807701#M1043763 <HTML><HEAD></HEAD><BODY><P dir="ltr"><SPAN style="font-size: 15px; font-family: Arial; color: #000000;">Algorithm</SPAN></P><P><SPAN><BR /><SPAN style="font-size: 15px; font-family: Arial; color: #000000;">Hi,</SPAN><SPAN style="font-size: 15px; font-family: Arial; color: #000000;"><BR class="kix-line-break" /></SPAN><SPAN style="color: #000000; font-size: 15px; font-family: Arial;">I need to find a solution to calculate when activities occurs. I want to do this in the load script. As example an activity happens on Mondays and Thursdays every 5th week&nbsp; during 1.5 year.</SPAN></SPAN></P><P><SPAN style="font-size: 15px; color: #000000; font-family: Arial; line-height: 1.5em;">Thank's <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR />&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-size: 15px; font-family: Arial;"><BR /></SPAN></P></BODY></HTML> Mon, 24 Nov 2014 11:56:17 GMT https://community.qlik.com/t5/QlikView/Date-for-occurrence/m-p/807701#M1043763 2014-11-24T11:56:17Z Re: Date for occurrence https://community.qlik.com/t5/QlikView/Date-for-occurrence/m-p/807702#M1043764 <HTML><HEAD></HEAD><BODY><P>I figured out the answer when posted question...</P><P><BR />In first step:<BR />1) calc no of dayes for the time interval<BR />2) Add a flag if it correct weekday</P><P></P><P>Second step:</P><P>3) A modulus calc if the Flag is correct:<BR />if(Flag=1,if(Mod(Counter,WEEKPER)=0,1,0),0) as Flag</P></BODY></HTML> Mon, 24 Nov 2014 13:18:34 GMT https://community.qlik.com/t5/QlikView/Date-for-occurrence/m-p/807702#M1043764 2014-11-24T13:18:34Z