Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
lorenzgrn
Contributor
Contributor

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

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

 
 

Immagine.gif

 

1 Solution

Accepted Solutions
sergio0592
Specialist III
Specialist III

So, try with

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

 

View solution in original post

2 Replies
sergio0592
Specialist III
Specialist III

Hi,

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

sergio0592
Specialist III
Specialist III

So, try with

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

 

View solution in original post