topic Re: Straight Chart - Row Background Color in QlikView

Straight Chart - Row Background Color

Anonymous — Thu, 17 Oct 2013 16:29:27 GMT

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.

Re: Straight Chart - Row Background Color

Anonymous — Thu, 17 Oct 2013 16:43:47 GMT

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

Re: Straight Chart - Row Background Color

Anonymous — Thu, 17 Oct 2013 17:49:22 GMT

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.

Re: Straight Chart - Row Background Color

Anonymous — Thu, 17 Oct 2013 23:18:52 GMT

Or writing a Macro would be a better idea?