Multivalued field and Colors in View

I am trying to use “value as color” in a view. However, the field I am using is a multi value field, shown as separate entries.

@if(columnX= “Yes”; red; black)

Works on the entries that are equal to “Yes”, but then all other entries from the same document are RED, even if the value of that entry is black.

Am I missing something? Anyway around this?

Thanks.

Subject: Multivalued field and Colors in View

I think the issue that you are having is that a document’s column is only calculated once, even if you have it being displayed multiple times. All computed columns are going to have the same value for the same document.

Subject: RE: Multivalued field and Colors in View

I agree with Graham that you’re not going to be able to get the same document to appear multiple rows in different colors, but also note that the test columnX= “Yes” when columnX is multivalued, will return True if any value in columnX = “Yes”. So if columnX contains “No” : “No” : “Yes” : “No” then columnX = “Yes” is true.

Subject: RE: Multivalued field and Colors in View

Got it. I was just trying to simplify the code for the sake of the example, but the answer is still the same, no different colors for same document, even though they appear as different rows in the view. Right?

Thanks for the responses!