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: 
lernherk
Contributor
Contributor

Gauge Measure Expression to filter by a date and by a facility

Hi, I'm trying to come up with an expression for my measure that filters a date field by what is after today and also by a certain facility. The first part of my expression is working:

Count({<ExpirationDate={">$(=Date(today(),'YYYY-MM-DD'))"}>}UserId)/Count(UserId)

This expression gives me the correct percentage of total users that have an expiration date of after today. I also need to filter this by FacilityID = 1024.

Any help is appreciated!

 

1 Solution

Accepted Solutions
sunny_talwar

May be this

Count({<ExpirationDate={">$(=Date(today(),'YYYY-MM-DD'))"}, FacilityID = {1024}>} UserId)/Count(UserId)

or this

 

Count({<ExpirationDate={">$(=Date(today(),'YYYY-MM-DD'))"}, FacilityID = {1024}>} UserId)/Count({<FacilityID = {1024}>} UserId)

View solution in original post

2 Replies
sunny_talwar

May be this

Count({<ExpirationDate={">$(=Date(today(),'YYYY-MM-DD'))"}, FacilityID = {1024}>} UserId)/Count(UserId)

or this

 

Count({<ExpirationDate={">$(=Date(today(),'YYYY-MM-DD'))"}, FacilityID = {1024}>} UserId)/Count({<FacilityID = {1024}>} UserId)
lernherk
Contributor
Contributor
Author

The second solution worked - thank you so much!!