Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Population Pyramid Chart

cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist II

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
Master II
Master II

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

Regards

Andy

0 Likes
hkg_qlik
Creator III
Creator III

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

0 Likes
krishna20
Specialist II
Specialist II

Thank You All..

0 Likes
Not applicable

Useful one!!! Thanks for sharing

0 Likes
marjan_it
Creator III
Creator III

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

0 Likes
burli1895
Contributor III
Contributor III

Hi Marjan,

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

0 Likes
Version history
Last update:
‎2015-10-23 02:52 AM
Updated by: