Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BexaUK83
Contributor
Contributor

Fixing a filter =< to a report or specific table

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.

Labels (2)
3 Replies
JuanGerardo
Partner - Specialist
Partner - Specialist

Hi @BexaUK83, you can try with something like:

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

JG

BexaUK83
Contributor
Contributor
Author

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
Partner - Specialist
Partner - Specialist

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

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

JG