Discussion board where members can learn more about Qlik Sense App Development and Usage.
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?
Data:load * inline [Team, Week, ValueA,1,27A,2,10B,1,1B,2,69
if(sum(Value) - before(sum(Value)) < 0 , red(),green())
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)