Coloring by expression based on Average of values per row in pivot table

[lorenzgrn]

Hi, I have a pivot table like this (without coloring) in qliksense with all the weeks of the year and indeed I would like to apply background color based on expression. The expression should be based on the average of every single row, so for example for person1 the average is 4.8 and for this value I would like to apply light Yellow in the background. Is there anyone who could help out with the expression? Thank you very much in advance

[sergio0592]

Hi,

So you want orange color if average <5 and green color if average >5. What are the conditions ?

[sergio0592 · Accepted solution]

So, try with

if(avg(TOTAL <Personne> Value)<5,rgb(255,181,151),rgb(151,255,151))