Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Replicating Scatter Graph from Excel (Boston Consulting Group (BCG) Matrix)

Can anyone help?

I am trying to replicate the following graph that I produced in excel. The data behind the graph scores applications for business health and technical health based on averaging the scores againest a set of criteria. The criteria are categorised as either business or health related. Therefore I calculate the average business score and average techncial an plot a point on the grid for each application. Excel is difficult to use but I can get to a single view as shown below. What I cant do easily in excel is create an interactive map that enables me to show just the applications belonging to a particular group.

These graphs are sometimes referred to as a Boston Consulting Group (BCG) Matrix, or Boston Consulting Grid.

Presentation1.jpg