Change color of cells depending of the previous values

[ecabanas]

Hi,

I'm making a pivot table and if depending on the value the cell becomes green or red. for example, if February is lower than January, red, if not, green.

I'm using this expression in measure --background colour:  if(Sum({<CalendarMonthName_C= >}  Import_Brut )<=before(Sum({<CalendarMonthName_C= >}  Import_Brut )),rgb(216,126,126),rgb(152,192,158))

and It works

But when I select a month, the table did not filter and remains with colours but cero values

Could you help to me?

thank's

[sunny_talwar]

Did you uncheck 'Include Zero Values' under Add-ons -> Data Handling?

[ecabanas]

yes, all unchecked and in qlikview works perfect and in Sense no.

thank's

[sunny_talwar]

Would you be able to share your sense app to check this out?

[sunny_talwar]

Also, try to use this expression and see if this helps

If(Sum(Import_Brut) <= Before(Sum({<CalendarMonthName_C>} Import_Brut)),
RGB(216,126,126),
RGB(152,192,158))

[ecabanas]

I'm new in Sense, I'm developing in server mode, how could I do that?

thank's

[sunny_talwar]

Do you have access to the QMC?

[ecabanas]

did not work, the same result