Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

How to Create the Magic Quadrant Chart

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Steven_Haught
Creator III
Creator III

How to Create the Magic Quadrant Chart

Last Update:

Aug 5, 2020 12:53:03 PM

Updated By:

Steven_Haught

Created date:

Aug 5, 2020 12:53:03 PM

Attachments

How to Create the Magic Quadrant

A magic quadrant chart is possible with the use of the basic map chart and various layers. This will use the basic map chart in the included charts. This will also use point layers for the symbols and area layers for the grid. It has endless capabilities for use!

  1. Add the map chart.
    1. In Map Settings set the Base map to NONE.
    2. Set Projection to User Defined Degrees.
    3. Turn Off Legend in Legend Setting.
    4. Turn off Scale Bar in Presentation Settings.
  1. Add area layers for box.
    1. Add a layer titled box.
    2. Dimension equals 1.
    3. Location equals: ='[[[0,0],[100,0],[100,100],[0,100]]]'
  1. Add area layers for Grid.
    1. If using a 4 quadrant plane use the following:
      1.      Add a layer titled Grid.
      2.      Dimension equals 1.
      3.      Location equals: ='['& '[[0,0],[50,0],[50,50],[0,50]],' & '[[50,50],[100,50],[100,100],[50,100]]' & ']'
    2. If using a 16 quadrant plane use the following:
      1.      You need to add 4 grid layers.
      2.      Each dimension is equal to 1.
      3.      Locations are as follows:

Grid1: ='['&'[[0,0],[25,0],[25,25],[0,25]],' &'[[25,25],[50,25],[50,50],[25,50]]'& ']'

Grid2: ='['&'[[50,0],[50,25],[75,25],[75,0]],' &'[[75,25],[100,25],[100,50],[75,50]]'& ']'

Grid3: ='['&'[[0,50],[25,50],[25,75],[0,75]],' &'[[25,75],[25,100],[50,100],[50,75]]'& ']'

Grid4: ='['&'[[50,50],[75,50],[75,75],[50,75]],'&'[[75,75],[100,75],[100,100],[75,100]]'& ']'

  1. Set Grid and Box Colors to desired colors.
  2. For your dots or bubbles on the grid, add a point layer
    1. Use a unique dimension for the point layer.
      1.      If you need separate type shapes, limit your dimension and set shape in settings.
    2. As location you need to have two separate fields with values that range from 0-100
      1.      Set the “Y” value as the Latitude.
      2.      Set the “X” value as the Longitude.
    3. If desired color by a particular method.

Quadrant Labels

For Labels you will need to add another point layer.

  1. Add point layer.
  2. Dimension is Label.
  3. Location is as follows:
    1. LabelY as Latitude.
    2. LabelX as Longitude.
  4. Make bubble size 0 and opacity far left.
  5. Under general options set show labels to ON and Centered.
  6. Inline load with coordinates is as follows:

4 Quadrant

QuadrantLabels:

load * Inline [

Label, LabelX, LabelY

UpperRight, 75, 98

UpperLeft, 25, 98

LowerRight, 75, 2

LowerLeft, 25, 2

];

 

16 Quadrant

load * Inline [

Label, LabelX, LabelY

X4, 87.5, 2

X3, 62.5, 2

X2, 37.5, 2

X1, 12.5, 2

Y1, 2,12.5

Y2, 2,37.5

Y3, 2,62.5

Y4, 2,87.5

];

 

Finished ProductFinished ProductMQ4.JPG

Link and QVF of  Inspiration for work:

https://community.qlik.com/t5/Qlik-Sense-Documents-Videos/Top-10-Visualization-tips-QlikWorld-2020/t...

Contributors
Version history
Last update:
‎2020-08-05 12:53 PM
Updated by: