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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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