How to create Scatter Plot Quadrants?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello Everyone!

I'm fairly new to qlikview, and I'm exploring different chart types.

I need to develop a Scatter Chart. I have Age (from 0 - 100) on the X axis, and I have income on the Y axis. I have also used conditions to have bigger bubble size for bigger income.

I want to create quadrants that classify these data points into High and Low Income and Age.

I used to reference line option to do this. I am not sure what kind of condition to use here.

I want to maybe use mean, median or mode for income, and use a constant number (say 45 years) for Age.

I also want these lines to remain static. One problem i have faced is that when I select an area of the chart to display just those data points, the reference lines recalculate by using just those data points. This is quite confusing.

Ex:

Before any selections are made, the reference lines for income and age are at $35,000 and 35 years.

I want to see the data points in the High Income, High Age Quadrant, so i select those data points.

The reference line now recalculate to show $100,000 and 55 years.

But I want it to stay at the original values.

Hope someone can help me with this. (I have a personal version of qlikview and I cannot open qv files that are shared)

Thank you.

topic How to create Scatter Plot Quadrants? in QlikView

How to create Scatter Plot Quadrants?