Qlik Community

QlikView Documents

Documents for QlikView related information.

Population Pyramid Chart

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


Population_Pyramid.png


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


Regards


Krishna



Attachments
Comments
ogster1974
Honored Contributor II

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

Regards

Andy

hkgandhi
Contributor II

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

krishna20
Valued Contributor

Thank You All..

Not applicable

Useful one!!! Thanks for sharing

marjan_it
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

burli1895
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: