Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
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

Creator
Creator

yes, AND is what I need.

Thank you !