sense label negative in red

[everest226]

sense Nov release 

I have a measure, how to show total in red when its negative  

[hopkinsc · Accepted solution]

Hi. 

In the background colour expression use an If() statement. 

If([Expression]<0,RED(),GREEN())

You have posted this in the QlikView pages whereas it should be in the Qlik Sense pages (Just o make you aware) 🙂

[everest226]

Thanks

[hopkinsc]

Actually ive just noticed that you need the total row coloured. I'll look at that now

[everest226]

Thanks Let me know if it is possible.