Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)