topic Re: Colour cell based on previous week numbers in App Development

Colour cell based on previous week numbers

jgreen95 — Thu, 21 Nov 2019 15:40:39 GMT

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

Re: Colour cell based on previous week numbers

y_grynechko — Thu, 21 Nov 2019 18:22:14 GMT

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:

Re: Colour cell based on previous week numbers

jgreen95 — Fri, 22 Nov 2019 07:45:06 GMT

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)