Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
aheavy95
Contributor III
Contributor III

backgroung color not works completely

Hi all,

In a report, I wanted to mark in red columns which dont get a CustomerName field.

I used this formula in the background color expression: 

if(IsNull([Primary Supplier Info]) or [Primary Supplier Info]='-',red(), )

 

for some reason it colors only a few of the rows, any idea why?

aheavy95_1-1660663283957.png

Thanks a lot 

Aon

 

 

 

 

Labels (4)
1 Solution

Accepted Solutions
Frank_S
Support
Support

Hello 
Perhaps try this...

Make a copy of your measure expression and replace the 'else' with the background color.

In this example you are replacing 'Below Sales Target' with Yellow()  


Measure expression example
=if(sum(Sales)>10000,sum(Sales),'Below Sales Target')

Background Color Expression
=if(sum(Sales)>10000,sum(Sales),Yellow())

 


We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!

View solution in original post

1 Reply
Frank_S
Support
Support

Hello 
Perhaps try this...

Make a copy of your measure expression and replace the 'else' with the background color.

In this example you are replacing 'Below Sales Target' with Yellow()  


Measure expression example
=if(sum(Sales)>10000,sum(Sales),'Below Sales Target')

Background Color Expression
=if(sum(Sales)>10000,sum(Sales),Yellow())

 


We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!