topic Firstworkdate with holiday in QlikView https://community.qlik.com/t5/QlikView/Firstworkdate-with-holiday/m-p/119956#M18433 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I want to add holiday list into firstworkdate function. With <STRONG>checkwd</STRONG> is a field contains 1 and 0 ( if 1 is holiday )</P><P></P><P>this is my expression but its result not what i want</P><P></P><P>firstworkdate(max(Tradedate),5,<STRONG>concat(${&lt;checkwd={'1'}&gt;}Tradedate,',')</STRONG>)</P><P></P><P>Many thanks for your help </P></BODY></HTML> Sun, 08 Jul 2018 03:25:50 GMT phongnnguyen 2018-07-08T03:25:50Z Firstworkdate with holiday https://community.qlik.com/t5/QlikView/Firstworkdate-with-holiday/m-p/119956#M18433 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I want to add holiday list into firstworkdate function. With <STRONG>checkwd</STRONG> is a field contains 1 and 0 ( if 1 is holiday )</P><P></P><P>this is my expression but its result not what i want</P><P></P><P>firstworkdate(max(Tradedate),5,<STRONG>concat(${&lt;checkwd={'1'}&gt;}Tradedate,',')</STRONG>)</P><P></P><P>Many thanks for your help </P></BODY></HTML> Sun, 08 Jul 2018 03:25:50 GMT https://community.qlik.com/t5/QlikView/Firstworkdate-with-holiday/m-p/119956#M18433 phongnnguyen 2018-07-08T03:25:50Z