QlikSense - pivot table - change color of cell vs average of grouping

[#1]

Hi - this is my first post and I am just learning QlikSense.  Thanks in advance for your help.

I cannot upload my data due to confidentiality.

I have a pivot table that looks like the table below.

I would like to be able to color code the cells where the unit values are below average in red and above average in green.

The value for "average for task" is a row in my data set.  I would need some kind of formula that references the average cell, within each grouping for comparison to the current cell value. 

I hope all that makes sense. Any help / guidance / link to a place where I can RTFM are all appreciated.

Task / Employee	Q1	q2
Task 1
employee 1	5 units	10 units
employee 2	10 units	20 units
employee 3	15 units	30 units
Average for Task	10 units	20 units
Task 2
employee 1...	xx	xx

[sinanozdemir]

Hi,

Not that I am aware of. However, you can bring the dimensions as measures and then do your color manipulation.

Thanks

[#3]

Hi,

I am working with pivot table   i want to color  my data according to the highest and lowest  amount bugeted or consummed.

e.g highest can be from >= 1000000  color green() lowest amount <1000000 color red() the clor should show in all the rows

How do I create the expression.

I also want to determine the expenditure rate using the ACTUAL BUDGET vs the COUNSEMED AMOUNT

PROJECT ID	BUDGET	ACTUAL BUDGET	CONSUMED AMOUNT	AVAILABLE BALANCE	Header 6	Header 7
001	20000000	30000000	10000000	400000
003	500000	14000000	567990	600000
002	4500000	20000000	2760000	100590
009	3000000	2504500	3210000	471230
006	15000000	5680000	160000	5000
007	12000000	34600000	1230000	45890
005	500000	23333333	1000000	200001
010	160000	67777555	60000	6600

[sanjay006]

That you can give in background color expression.And that you have to give in all column in which in you want to use the color code.

[#5]

What do you mean?