Fixing a filter =< to a report or specific table

[BexaUK83]

Hi all, 

Unfortunately had a bit of time away from Qlik and now having to re-familiarise myself after 2 years away. 

I have a report on working days which I want to limit to seeing an employee who leaves =to or <less than 30 days. This is a KPI measurement for us. I have looked across the board and I am struggling to come up with a formula to limit the range? 

Any suggestions please? 

Thank you in advance.

[JuanGerardo]

Hi @BexaUK83, you can try with something like:

Count({<IsWorkingDay = {1}, LeaveDate = {"<=Date(Today()-7, 'MM/DD/YYYY')"}>} Distinct Date)

JG

[BexaUK83]

Hi, thanks for the quick response. 

I have interpreted your formula in the following way but I am still getting an error.

 Count({<startDate = {1}, LastDate = {"<=Date(Today()-7, 'MM/DD/YYYY')"}>} Distinct Date)

[JuanGerardo]

:-O, I forgot to use the $ expansion:

Count({<startDate = {1}, LastDate = {"<=$(=Date(Today()-7, 'MM/DD/YYYY'))"}>} Distinct Date)

JG