Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I colour the background of negative Sales Variance numbers in a table

Hello everybody,

I've been trying to colour the background of negative Sales Variance % in a table and it has worked in other tables before, but not this time. This is the table  where I want to colour the background red (Sales Variance%):

Skärmklipp2.PNG

The expression for Sales Variance % looks like this:

Sum({$<Year={$(=Max(Year))}, Mon={$(=Month(Today()))}>}Sales)/

Sum({$<Year={$(=Max(Year)-1)}, Mon={$(=Month(Today()))}>}Sales) - 1

Can anyone tell me how I can write an expression that makes the colour in the background red?

Sincerely,

Betty Habtemariam

Labels (1)
10 Replies
reddy-s
Master II
Master II

Glad It helped!