Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Straight Chart - Row Background Color

I have three straight charts, all have common Dimension i.e. Client and one expression each. The requirement is if the Client Name appears twice in all three charts then make the background color of Dimension and Expression as Blue, if it appears three times make it Green other wise no color. Applying color coding on object level could work but not sure how to consider three objects at a time and rest of the objects on the sheet should not get affected.

Thank you for any suggestions.

3 Replies
Anonymous
Not applicable
Author

Hi

What are the three expressions?

As what I think you will have to do is somehow merge them into a single expression to do your colour coding on each straight Table Charts by looking at the data.

Best Regards,     Bill

Anonymous
Not applicable
Author

All three are very similar:

=sum({<Week={"<=$(vCurrWeek)"}, Year={$(vCurrYear)}, Region={'Americas'}>} Sales)

=sum({<Week={"<=$(vCurrWeek)"}, Year={$(vCurrYear)}, Region={'Europe'}>} Sales)

=sum({<Week={"<=$(vCurrWeek)"}, Year={$(vCurrYear)}, Region={'Asia'}>} Sales)

One thing to add here is all these charts are being limited (through Dimension Limits) to Top10 Sales.

Anonymous
Not applicable
Author

Or writing a Macro would be a better idea?