https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/1730147#M452239 <P>Hello ,</P><P>I have a field startdate</P><P>i need to count of days from start to today and exclude sat,sunday and holidays</P><P>&nbsp;</P><P>COUNT({&lt;FINALWEEKDAY -= {'Sun','Sat'},FINAL_FLAG = {'WORKINGDAY'}&gt;}DATE(Today(),'DD-MM-YYYY') - ZDATE_FROM)</P><P>Please correct my expression</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:19:35 GMT Surya 2024-11-16T18:19:35Z https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/1730147#M452239 <P>Hello ,</P><P>I have a field startdate</P><P>i need to count of days from start to today and exclude sat,sunday and holidays</P><P>&nbsp;</P><P>COUNT({&lt;FINALWEEKDAY -= {'Sun','Sat'},FINAL_FLAG = {'WORKINGDAY'}&gt;}DATE(Today(),'DD-MM-YYYY') - ZDATE_FROM)</P><P>Please correct my expression</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:19:35 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/1730147#M452239 Surya 2024-11-16T18:19:35Z https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/1730376#M452252 <P>See duplicate post:</P><P><A href="https://community.qlik.com/t5/New-to-QlikView/Set-Analysis/m-p/1730142#M391448" target="_blank">https://community.qlik.com/t5/New-to-QlikView/Set-Analysis/m-p/1730142#M391448</A></P><P>Regards,<BR />Brett</P> Thu, 23 Jul 2020 16:51:31 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/1730376#M452252 Brett_Bleess 2020-07-23T16:51:31Z