Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jgreen95
Contributor III
Contributor III

Colour cell based on previous week numbers

 

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
Team1234
A27105672
B1692072
C0911725
D33846366
E25866157
2 Replies
y_grynechko
Creator III
Creator III

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:

Capture.PNG

 

jgreen95
Contributor III
Contributor III
Author

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)