Multiple Colors in KPI

[arvindjha2050]

Hello Team,

Below is a script :

Color :

Load * Inline
[
Year1,Question,Value
2018,Score,88
2017,Score,86
2018,Unhappy,88
2017,Unhappy,89

];

In KPI i want to show difference of two years for Score and Dis based on qsVariable Extension where we have a dropdown for same.

The Colors logic is that if value of 2018 is greater than 2017 then value should be green else red [Only for Score]

For Unhappy it will be opposite , green for negative value and red for positive value.

In above case both should return green.

How to achieve it?

Thanks,

Arvind