Colour cell based on previous week numbers

[jgreen95]

I have a pivot table like below with team down the left and Week number across the top and i want to be able to colour the cell based on if it is higher or lower than the previous week

is this possible in Qlik Sense?

	Week
Team	1	2	3	4
A	27	10	56	72
B	1	69	20	72
C	0	91	17	25
D	33	84	63	66
E	25	86	61	57

[y_grynechko]

Load Script:

Data:
load * inline [
Team, Week, Value
A,1,27
A,2,10
B,1,1
B,2,69

];

Color expression:

if(sum(Value) - before(sum(Value)) < 0 , red(),green())

Result:

[jgreen95]

great thanks so if my fields are as below what do i need to put in the script?:

Team = SUPPLIER_SUMMARY

Week = WEEKENDING_DATE

Value = Count(NOTICE_NUMBER)