Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
new_guy
Contributor III
Contributor III

color of table rows

Hello, 

I want to color the text of my table rows. For this I use the following "if-clause" (**bleep**ty if-clause, I know, sorry for that ;-)): 

=if([A]='Agreed' and [B]='Commented by me' and [C]=1,rgb(130,66,159), 	
	if([A]='Open' and not [A]='Agreed' and ([B]='Commented by me' or 
        [B]='Agreed') and [C]=1,rgb(21,147,63),    
    	        if([A]='Closed' and [C]=1,rgb(182,215,234),
            	       if(([A]='Open' or [A]='Agreed') and 
                       ([B]='Answered by me' or [B]='For Approval') and 
                      [C]=1,yellow()))))

 

The problem is, that somehow the last if-clause is being ignored completely for coloring. The data behind it is processed correctly into my table, so I think there is basically no mistake within the whole if-clause. 

 

Does anyone have a suggestion how to do or fix this? 

 

Thanks!

0 Replies