Qlik Community

Qlik Sense Documents

Documents about Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT

How to Create the Magic Quadrant Chart

Creator III
Creator III

How to Create the Magic Quadrant Chart

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...

Labels (4)
Attachments
Version history
Revision #:
1 of 1
Last update:
‎2020-08-05 12:53 PM
Updated by:
 
Contributors