topic Firstworkdate with holiday in QlikView https://community.qlik.com/t5/QlikView/Firstworkdate-with-holiday/m-p/120535#M604470 <HTML><HEAD></HEAD><BODY><P>Dear guys,</P><P>I have a problem when use firstworkdate function with holiday list</P><P></P><P>My field Checkwd: is holiday determine, if Holiday or weekend 1 other is 0</P><P></P><P>this is my expression. I want find 5 day past without holiday and weekend.</P><P></P><P>firstworkdate(max(Tradedate),5,concat({&lt;checkwd={'1'}&gt;}Tradedate,','))</P><P></P><P></P><P>for example: they are holiday in my Tradedate</P><P><SPAN style="font-size: 13.3333px;">13 Jul 2018 </SPAN></P><P><SPAN style="font-size: 13.3333px;">15 Jul 2018 </SPAN></P><P>17 Jul 2018</P><P></P><P>max(tradedate)=17 Jul 2018 - &gt;and my expected result when apply expression is 9 Jul 2018</P><P></P><P>Many thanks for your help !</P></BODY></HTML> Sat, 07 Jul 2018 19:08:32 GMT phongnnguyen 2018-07-07T19:08:32Z Firstworkdate with holiday https://community.qlik.com/t5/QlikView/Firstworkdate-with-holiday/m-p/120535#M604470 <HTML><HEAD></HEAD><BODY><P>Dear guys,</P><P>I have a problem when use firstworkdate function with holiday list</P><P></P><P>My field Checkwd: is holiday determine, if Holiday or weekend 1 other is 0</P><P></P><P>this is my expression. I want find 5 day past without holiday and weekend.</P><P></P><P>firstworkdate(max(Tradedate),5,concat({&lt;checkwd={'1'}&gt;}Tradedate,','))</P><P></P><P></P><P>for example: they are holiday in my Tradedate</P><P><SPAN style="font-size: 13.3333px;">13 Jul 2018 </SPAN></P><P><SPAN style="font-size: 13.3333px;">15 Jul 2018 </SPAN></P><P>17 Jul 2018</P><P></P><P>max(tradedate)=17 Jul 2018 - &gt;and my expected result when apply expression is 9 Jul 2018</P><P></P><P>Many thanks for your help !</P></BODY></HTML> Sat, 07 Jul 2018 19:08:32 GMT https://community.qlik.com/t5/QlikView/Firstworkdate-with-holiday/m-p/120535#M604470 phongnnguyen 2018-07-07T19:08:32Z