Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

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

So, try with

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

 

View solution in original post

2 Replies
Highlighted
Specialist II
Specialist II

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

Hi,

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

Highlighted
Specialist II
Specialist II

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

So, try with

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

 

View solution in original post