Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using Color in Pivot Table Cell

I have about 10 pivot charts on a sheet that all deal with sales orders. Each chart contains Sales Order Number as a dimension. My users are asking if I can color code the order number in each chart IF the order number also exists in any of the other reports. Does anyone have a suggestion for how i could do this using a Text Color expression?

1 Reply
Anonymous
Not applicable
Author

Brian,
The question is more complex than just using color expression. The real problem is that the "current" object doesn't "know" anything about the other objects. You need some global attributes of the orders that indicate that an order is going to be used in a specific front end object - and use this attribute also to define color. Another possibility is to have a set of ten dynamic variables that lists order numbers that are contained in nine charts. I cannot suggest any more details, just trying to give an idea where to go...
As for the text color expression, it most likely will be a conditional expression like:
if(<condition based on order attributes>, rgb(r1,g1,b1), rgb(r2,g2,b2))