Comment faire une pyramide de comparaison ?

0
137

Introduction

PiramideEtaria3.PNG

This document shows you how to configure a bar chart to create a Population Pyramid visualization. By default, QlikView doesn’t have a Pyramid chart, but is possible to create one using a bar chart as a platform. On picture at side, population is split between gender and distributed along of years intervals. So, is possible see how many people are male or female, by period. Of course this technique is useful for different purposes. Sales, billing, products, etc. All you need to create this chart is a dimension and two expressions. Each expression will represented by a color. Therefore, for male and female is necessary two expressions, one for each gender. Sometimes, this data can be filled in one column, so, you should create two expressions using Set Analysis.

DataTable:

LOAD * INLINE [

  Interval, Male, Female

  More then 100 years old, 7.247, 16.989

  95 a 99 years old, 31.529, 66.806

  90 a 94 years old, 114.964, 211.595

  85 a 89 years old, 310.759, 508.724

  80 a 84 years old, 668.623, 998.349

  75 a 79 years old, 1.090.518, 1.472.930

  70 a 74 years old, 1.667.373, 2.074.264

  65 a 69 years old, 2.224.065, 2.616.745

  60 a 64 years old, 3.041.034, 3.468.085

  55 a 59 years old, 3.902.344, 4.373.875

  50 a 54 years old, 4.834.995, 5.305.407

  45 a 49 years old, 5.692.013, 6.141.338

  40 a 44 years old, 6.320.570, 6.688.797

  35 a 39 years old, 6.766.665, 7.121.916

  30 a 34 years old, 7.717.657, 8.026.855

  25 a 29 years old, 8.460.995, 8.643.418

  20 a 24 years old, 8.630.227, 8.614.963

  15 a 19 years old, 8.558.868, 8.432.002

  10 a 14 years old, 8.725.413, 8.441.348

  5 a 9 years old, 7.624.144, 7.345.231

  0 a 4 years old, 7.016.987, 6.779.172

];

Creating the Chart

Now you’ve data to be used to create a chart, use the following steps do create a Population Pyramid.

ChartType1.png

1. Create the chart clicking with right mouse button at any empty place on document and select New Sheet Objects.

2. When the shorcut menu is show, click Chart. Many types are available, but select the first one.

3. First one is a bar chart. After selected it, click Next button.

4. The Dimensions window is showed. From available fields, click Interval and add it to Used Dimensions.

ExpressionBarChart2.PNG

5. Click Next button to show expression window. Enter the following formula: =SUM(Male). After that, click Ok.

6. Click Add button to enter a new expression. Enter the following formula: =SUM(Female) * -1

7. For each expression, change the Label properties to Male and Female, respectively.

8. For both expressions, click Values on Data Points.

ChartOrientationSubtype1.png

9. Go to next step clicking Next button. In Sort tab, change text order for Internval field to Z > A.

10. Advance to next step clicking Next again. Now, change the chart orientation to horizontal. See image at side.

11. At same place, change the chart sub-type to stacked. See image at side.

12. Advance to Axes tab, clicking Next twice. Click Hide Axes.

13. Goto Number tab to change number formating. Use the following pattern for both expressions: #.##0;#.##0

This pattern has two parts. Before semicolon is used to formating positive numbers, while after semicolom is desined to format negative numbers.

14. Close wizard clicking Finish button.

Maybe you wanna change some properties to get a best design. Some aspects you can change are colors, position of legend, font size, etc.

LEAVE A REPLY

Please enter your comment!
Please enter your name here