topic Creation of a Population pyramid in QlikView

Creation of a Population pyramid

Thu, 16 Jul 2009 22:35:36 GMT

Hello everybody,

i would like to create a population pyramid, like the one below.

Anyway, i've the basis (a chart per gender) but i would like to integrate those two in one.

I haven't found how i can divide the axis ....

Can anyone help me on this topic ?

Thanks a lot 🙂

Creation of a Population pyramid

Wed, 05 Aug 2009 20:05:14 GMT

Hello

Here is how to create only one chart.

Create 2 expressions using set analysis

Women:

=Sum({1<Gender={'F'}>} Ratio)

Men:

=-Sum({1<Gender={'H'}>} Ratio)

Men will be displayed on the lefthandside and women on the right handside.

The above solution works fine if no data is to be displayed on the chart.

If 'Text on data point' is checked, Men are labeled with negative values. Is there a way to have labels with positive values on both sides?

Creation of a Population pyramid

prieper — Fri, 07 Aug 2009 03:34:44 GMT

Hi,

you may create a third expression repeating the abs-value of the negative one and switch off the display of the negative ones

see the attached example

HTH

Peter

Creation of a Population pyramid

matt_crowther — Tue, 16 Nov 2010 12:35:31 GMT

Below is my Qlikview (v9) based population pyramid chart - it's all fully drillable and behaves exactly like a native Qv object.

It's simple an compound overlay of 3 bar charts, by using actions the various objects that make up the chart can be made to minimize / maximize in the same way as traditional 'single' charts.

Hope that helps - I know it's been a while since the original post!

Cheers,

Matt

Creation of a Population pyramid

Tue, 16 Nov 2010 15:49:31 GMT

Hi Matt,

Indeed, it has been a while since the original post. Would it be possible to have your QVW file or a quick tutorial, i don't really see how you manage to create this chart.

Thanks a lot 🙂

Creation of a Population pyramid

matt_crowther — Wed, 17 Nov 2010 18:42:42 GMT

I'd be glad to post - file attached.

The data is simple test data loaded via an inline but this could easily be more complex data grouped into the age buckets - no reason why Dynamic User Defined Buckets couldn't be used.

Pulling it apart should give you all the answers you need - its simple once you get the transparency set correctly and the sharts lined up - one flaw however is that the axis labels are added manually as text objects as the left hand side would display negatives otherwise.

Hope it helps.

Matt - Visual Analytics Ltd