https://community.qlik.com/t5/QlikView/Utilizing-the-Now-Function-in-Set-Analysis/m-p/1910086#M1218070 <P>Try something like this.</P> <P>count({&lt;I.CompletedOn={"&lt;$(=now())"}&gt;}I.Invited)</P> Sat, 26 Mar 2022 08:59:05 GMT Vegar 2022-03-26T08:59:05Z https://community.qlik.com/t5/QlikView/Utilizing-the-Now-Function-in-Set-Analysis/m-p/1909935#M1218061 <P>Hey All,</P> <P>Im looking to see if someone can point me in the right direction as to how I properly set up a set analysis formula that leverages the Now() function and compares it to a date parameter with less than/greater than. I have attached what i currently have to this post (as for whatever reason, it gets locked out if i post the formula in the box), but i am basically attempting to get a count of interviews that have not been conducted at the time of viewing the table (Greater Than).</P> <P>Any insight would be appreciated!</P> Fri, 25 Mar 2022 15:24:14 GMT https://community.qlik.com/t5/QlikView/Utilizing-the-Now-Function-in-Set-Analysis/m-p/1909935#M1218061 Christopher_Lawrence 2022-03-25T15:24:14Z https://community.qlik.com/t5/QlikView/Utilizing-the-Now-Function-in-Set-Analysis/m-p/1910086#M1218070 <P>Try something like this.</P> <P>count({&lt;I.CompletedOn={"&lt;$(=now())"}&gt;}I.Invited)</P> Sat, 26 Mar 2022 08:59:05 GMT https://community.qlik.com/t5/QlikView/Utilizing-the-Now-Function-in-Set-Analysis/m-p/1910086#M1218070 Vegar 2022-03-26T08:59:05Z https://community.qlik.com/t5/QlikView/Utilizing-the-Now-Function-in-Set-Analysis/m-p/1910633#M1218115 <P>I think this would work for Interviews that were completed during the current time, opposed to before or after (looking for how to do it with greater than/less than opposed to equal).&nbsp;</P> Mon, 28 Mar 2022 13:40:39 GMT https://community.qlik.com/t5/QlikView/Utilizing-the-Now-Function-in-Set-Analysis/m-p/1910633#M1218115 Christopher_Lawrence 2022-03-28T13:40:39Z