Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
LesJean
Contributor III
Contributor III

Flag stock in other distribution centers

Hello Qlik community!

Here's my situation:

I have a table in which the items with a low days of coverage are listed. The item are splitted by IDs and Distribution Centers. So, I have the item "1" in the distribution centers "550" and "410" that have low days of coverage. This item is listed in the table, as you can see in this screenshot below.

Number1.png

I also have another table on another sheet which contains the data for the item in every distribution center, as you can see here:

Number2.png

As you can see, other distribution centers have 85+ days of coverage. If this condition is met, I'd like to flag it in the first table with a background color in the DOC (OH+OO) cell. 

How should I go about doing such a thing?

Thank you very much,

LesJean

Labels (3)
1 Solution

Accepted Solutions
andoryuu
Creator III
Creator III

This expression in the background color expression should help.  You can do a lot with color but i'm setting it to red just as an example.

If(COUNT({<[SKU]={"=Max({1}[DOC (OH+OO)])>=85"}>}[SKU])>0,Red())

View solution in original post

3 Replies
andoryuu
Creator III
Creator III

This expression in the background color expression should help.  You can do a lot with color but i'm setting it to red just as an example.

If(COUNT({<[SKU]={"=Max({1}[DOC (OH+OO)])>=85"}>}[SKU])>0,Red())

LesJean
Contributor III
Contributor III
Author

This works perfectly, thanks for your quick answer!

andoryuu
Creator III
Creator III

No problem, glad it worked out.