Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
donschmitz
Contributor III
Contributor III

Background color on Standard Table Subtotal line

I can change the color of a cell based on a condition but that does not work on the Total line.

 

Labels (3)
2 Replies
rubenmarin1

Hi, can you post the condition you are using?

Note that in total line all dimension values are present, probably one of your conditions can't be checked with all values at the same time.

donschmitz
Contributor III
Contributor III
Author

The formula for background color works fine for all data except the Totals line.

=IF ( COLUMN(4) > 0 AND COLUMN(5) > 0, GREEN(),
IF ( COLUMN(4) >= 0 OR COLUMN(5) >= 0, YELLOW(),
IF ( COLUMN(4) < 0 AND COLUMN(5) < 0, RED() )))

Basically you can not set a background color on a Total line.