Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Count a field with a certain expression applied

Hey All,
I created an expression:

if((Count ( {< Dateentered = {'06/2009'}>} Service) - Count ( {< Dateentered = {'05/2009'} >} Service)) < 0 ) , 'Green', 'red')


What the expression does is it subtracts the count of services this month and the prior month and if it is less then 0 then green else it is red. What I would like to do is count how many of the services are green, but I am unsure how to even begin. I tried just counting the expression but I get a -. Any thoughts?

1 Reply
Not applicable
Author

Hi,

just an idea.

See the attached application.

Rainer