topic Show 3rd Saturday in every month in QlikView https://community.qlik.com/t5/QlikView/Show-3rd-Saturday-in-every-month/m-p/68753#M11308 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I would like to Display 3rd saturday in all months</P><P></P><P>Can anyone help me out of this.</P><P></P><P>Regards,</P><P>Kishore.</P><P></P><P>PFA.</P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P><P><A href="https://community.qlik.com/qlik-users/178253">tamilarasu</A>‌</P><P><A href="https://community.qlik.com/qlik-users/26418">tresesco</A>‌</P></BODY></HTML> Fri, 20 Apr 2018 08:46:57 GMT kakani87 2018-04-20T08:46:57Z Show 3rd Saturday in every month https://community.qlik.com/t5/QlikView/Show-3rd-Saturday-in-every-month/m-p/68753#M11308 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I would like to Display 3rd saturday in all months</P><P></P><P>Can anyone help me out of this.</P><P></P><P>Regards,</P><P>Kishore.</P><P></P><P>PFA.</P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P><P><A href="https://community.qlik.com/qlik-users/178253">tamilarasu</A>‌</P><P><A href="https://community.qlik.com/qlik-users/26418">tresesco</A>‌</P></BODY></HTML> Fri, 20 Apr 2018 08:46:57 GMT https://community.qlik.com/t5/QlikView/Show-3rd-Saturday-in-every-month/m-p/68753#M11308 kakani87 2018-04-20T08:46:57Z Re: Show 3rd Saturday in every month https://community.qlik.com/t5/QlikView/Show-3rd-Saturday-in-every-month/m-p/68754#M11309 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(WeekDay(tran_date) = 'Sat' and Day(tran_date) &gt; 15 and Day(tran_date) &lt; 21, 1) as Third_Saturday</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/200318_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 20 Apr 2018 08:58:57 GMT https://community.qlik.com/t5/QlikView/Show-3rd-Saturday-in-every-month/m-p/68754#M11309 sunny_talwar 2018-04-20T08:58:57Z Re: Show 3rd Saturday in every month https://community.qlik.com/t5/QlikView/Show-3rd-Saturday-in-every-month/m-p/68755#M11310 <HTML><HEAD></HEAD><BODY><P>Happy to say this worked <STRONG>Sunny</STRONG></P><P></P></BODY></HTML> Fri, 20 Apr 2018 09:04:35 GMT https://community.qlik.com/t5/QlikView/Show-3rd-Saturday-in-every-month/m-p/68755#M11310 kakani87 2018-04-20T09:04:35Z