topic Need background color for every quadrant in scatter chart in QlikView

Need background color for every quadrant in scatter chart

Wed, 12 Jun 2013 09:20:32 GMT

Hi,

I have a scatter chart, i will get x and y-axis line using my own expression (not the chart x-axis or y-axis).

It's a custom x-axis and y-axis, so it will have 4 quadrants. I want to color individual quadrants with different colors.

Is it possible to do?

If yes, how we can achieve this?

I want to color the quadrants with different colors or atleast the bubbles falls under one quadrant should have one color and other quadrant bubbles should have different color, but bubbles under same quadrant should have same color.

Re: Need background color for every quadrant in scatter chart

Gysbert_Wassenaar — Wed, 12 Jun 2013 09:35:53 GMT

You can give the bubbles different colors with the Background Color setting of the x-axis expression. See attached example.

If you want the quadrants themselves to have background colors you need to used colored textboxes and put the scatter chart on top of them and make the plot area transparent.

Re: Need background color for every quadrant in scatter chart

Wed, 12 Jun 2013 09:36:45 GMT

if you want the background with different color maybe you can use a colored defined by a function

if(x>0 and y>0, rgb(xxx,xxx,xxx) , if ( x>0 and y <0, rgb ........

Re: Need background color for every quadrant in scatter chart

Wed, 12 Jun 2013 09:41:32 GMT

well sorry my solution doesn't seem to be working

Re: Need background color for every quadrant in scatter chart

Wed, 12 Jun 2013 09:57:52 GMT

Hi Gysbert,

I checked the file, i wanted similar to that functionality,

but you have given the conditions in background color of expression like

if([Per capita GDP]>3000 and [Life expectancy]>60, blue(),

if([Per capita GDP]<3000 and [Life expectancy]<60, red(),

if([Per capita GDP]>3000 and [Life expectancy]<60, green(),

rgb(255,128,0))))

but in my case, [Per Capita GDP] is a huge expression and 3,000 value also is an expression stored in a variable.

The quadrants are dynamic based on selection.

Re: Need background color for every quadrant in scatter chart

Wed, 12 Jun 2013 09:58:39 GMT

hi yadu,

In my case, the quadrants in bubble chart is dynamic.

it will change based on selections.

Re: Need background color for every quadrant in scatter chart

Gysbert_Wassenaar — Wed, 12 Jun 2013 10:05:57 GMT

Doesn't matter. The Background Color expression uses the label names of the chart expressions. And you can replace the hardcoded values with variables if necesarry.

Re: Need background color for every quadrant in scatter chart

Wed, 12 Jun 2013 10:35:22 GMT

Ok thanks for the help.

I will try it out.