Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Highlighted
blakeB
New Contributor II

Conditional Color based on previous month's value

Hi Everyone,

I imported an excel table (column 1: month, column 2: sales) and wanted to know if there was a way to conditional color based on the previous month's sales figure (for example: if previous month sales is less than current month sales, green, otherwise red).

I'm using: 

sum({<Month={'$(=max(Month))'}>} [Sales])
 
to reference the most recent month's sales entry to display in the KPI, and wanted to display the metric red or green based on previous month. 
Community Browser