# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for
Did you mean:
Highlighted
Creator

## background-color dependent on several conditions

Need to set the background color of an article number in a pivot-table dependent on the following conditions

- number of customers (distinct) >= X

- quantity >= Y

- sales€ >= Z

For a KPI-figure, i used the following:

count({<Menge = {">=1000"}, KundeNr = {">=25"}>} KundeNr)

But for the background, I have no idea, how to set up a formula with multiple conditions

Reinhold

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary

You need to combine these conditions porbably per AND like:

if(

count({<Menge = {">=1000"}, KundeNr = {">=25"}>} KundeNr) > x

AND

sum(sales) > y

AND

sum(quantity) > z,

green(), red())

- Marcus

4 Replies
Highlighted
Champion
Highlighted
Creator

value vor quantity and sales€

count for number of customers

Highlighted
MVP & Luminary

You need to combine these conditions porbably per AND like:

if(

count({<Menge = {">=1000"}, KundeNr = {">=25"}>} KundeNr) > x

AND

sum(sales) > y

AND

sum(quantity) > z,

green(), red())

- Marcus

Highlighted
Creator

yes, AND is what I need.

Thank you !