Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JohnSamuel123
Contributor III
Contributor III

Qlik find value in a field, expression

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

JohnSamuel123_0-1631788482634.png

 

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

 

thanks

 

1 Solution

Accepted Solutions
stevejoyce
Creator III
Creator III

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)

View solution in original post

1 Reply
stevejoyce
Creator III
Creator III

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)

View solution in original post