topic Shading graph sections in QlikView

Shading graph sections

Wed, 31 Aug 2011 21:16:58 GMT

Hi all,

I am looking to create a shaded area(s) on graphs to highlight when something is out of bounds or exceeding a threshold.

for example: Scatter chart of price vs. volume. I would like a shaded area when the price is above X and/or below Y.

similar with a bar chart.

How about one that is dynamic, like a variance area of >10%?

thanks,

Bernard

Shading graph sections

swuehl — Wed, 31 Aug 2011 21:36:26 GMT

Have you already looked at the expression attributes where you can set the bargraph color by expression (called Background Color there, but IMHO that's the bar's color). Goto Expression tab, open the attributes section by clicking on the + sign next to the expression. For example in a bar chart, set the Background Color to an expression, where you compare the expression used to a fixed or variable value (for example calculate the mean and compare with +-10% variance).

Or do you want something totally different?