In this example, I need to display for the customer A the sales amount for 2017 in red because the sum of sales amount for 2016 is upper than in 2017.
For the customer B, I need to display the sales amount for 2017 in green because the sum of sales amount for 2016 is lower than in 2016.
PFA. Using your data (subfield function and qliksense version)
just use below text color expression like this
if your issue got resolved, help to close this thread by marking as correct. thanks
subfield.qvf 192.0 K
I'd like to do it for this kind of table.
What is the formula I should use ?
load * Inline [Customer,Product,Year,SalesAmount