New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
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 !