Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
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