Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Creator
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
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

View solution in original post

4 Replies
Highlighted
Champion
Champion

Highlighted
Creator
Creator

value vor quantity and sales€

count for number of customers

Highlighted
MVP & Luminary
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

View solution in original post

Highlighted
Creator
Creator

yes, AND is what I need.

Thank you !