Qlik find value in a field, expression

[JohnSamuel123]

hi,

i have an expression that changes the font colour dependent on time:

""if (Interval(vNow-max([Actual Date])<= '08:30:00'), rgb(254, 92, 90))""

however, i want to include another "and"  statement that will look at my field named "descriptor" and find if there are any records with the value "collection".  

issue is that there are multiple records with different "descriptor" values. i want qlik to just identify if there is a "collection" record without having the user have to select it

e.g if there is a record with the "collection" value, qlik catches it without user having to click collection themselves.

thanks

[stevejoyce · Accepted solution]

this will count instances of collection intersected with current selections.  if this is > 0, you have a Collection in your selections

count(total {<DESCRIPTOR*={'Collection'}>} DESCRIPTOR)