Qlik Community

QlikView Documents

Documents for QlikView related information.

Population Pyramid Chart

Valued Contributor

Population Pyramid Chart

Hi Folks,

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.


Steps to Create Population Pyramid

   1. Select a Bar chart , Take Interval (Field) as a Dimension.

   2. Add Expressions -> Sum(Male) and Sum(Female)*-1.

   3. Enable Value on Datapoints for both the Expressions.

   4. Goto Sort tab -> Select Text -> Z >A.

   5. Goto Style tab-> Select first chart-> Select horizontal chart -> Subtype-> Select Stacked.

   6. Goto tab Axes -> Select Hide Axis for both the Expressions.

   7. Goto Number tab -> Select Integer -> Edit this format #.##0;#.##0 for both the expressions; (This pattern has two parts.            Before semicolon is used to formating positive numbers, while after semicolom is desined to format negative numbers).

   8. Finish.

Please find the attached Sample Document for clear Understanding.

Courtesy : www.qknow.com



Honored Contributor II

Nice example I saw someone looking for a solution to this a few weeks back.



Contributor II

Nice chart for the type of data you are comparing. Thanks for sharing !

Valued Contributor

Thank You All..

Not applicable

Useful one!!! Thanks for sharing

Contributor II

I make a age pyramid like this but I want to show data in percentage when I show in percentage, this bar shows percentage negative data. what can I do to show all data in positive ?AgePyramid.png

New Contributor III

Hi Marjan,

set the Format to #.##0,00 % ;#.##0,00 %

Version history
Revision #:
1 of 1
Last update:
‎10-23-2015 02:52 AM
Updated by: