The issue at hand: What is a Scatter Chart? When and how should be used?
Scatter chart is mostly used to analyze data points (coordinates) and the relation between them.
The pattern of the points in the chart may provide an idea of the relation between the pairs of points (coordinates); for example, creating a scatter chart to analyze the relation between GPM to the Volume of Sales.
Use scatter when you need to prove or refute cause/effect relationships and identify problematic trends.
A Scatter chart will mostly allow to identify:
– Strong positive trend – Y and X values increase fast.
– Strong negative trend – Y and X values decrease fast.
– Moderate positive trend – Y increase slowly while X values increase.
– Moderate negative trend – Y decrease slowly while X values increase.
– Mixed – Since there is a relation between the point, the trend is not conclusive.
– No clear relation between the coordinates.
There is also the possibility to add a third dimension working on the size of the point themselves; for example when creating scatters to analyze Country Population in relation to GDP (per capita) and Life Expectancy, where
– Axe X = GDP per capita
– Axe Y = Life Expectancy
– Country Population = point size
Creating a Scatter chart in QlikView documents require the use of Aggregation functions, so Sum or Avg will be used depending on the underlying data. Once the expression with the aggr is created, it is recommended to switch to “advance mode” that allows making changes on the dimensions.
Removing the option “Force 0” and using logarithmic scale may improve the design of the chart.