topic Re: Population Pyramid in QlikView

Population Pyramid

Mon, 22 Feb 2016 23:10:18 GMT

Can anyone explains to me what those expression mean?

Sum({<Sex={'female'}>}Population)
-Sum({<Sex={'male'}>}Population)
Sum({<Sex={'female'}>}Population) / sum(Population)
=num(100*(Sum({<Sex={'female'}>}Population)) / Sum(Population)) , '##.#'& '%'

Re: Population Pyramid

johnw — Tue, 23 Feb 2016 00:58:30 GMT

Sum of female population
Negative sum of male population
Percentage of population that is female
Someone displaying that percentage incorrectly. Instead of this, expression #3 should be used, and change the numeric formatting in the chart to percentage. There might be a reason it's handled this way in this specific case, of course.

Re: Population Pyramid

HirisH_V7 — Tue, 23 Feb 2016 05:02:44 GMT

Hi,

Hope they are fine expect the 4 th as John Mentioned. Can you elaborate and tell what your are looking to see in the 4th Expression !

Re: Population Pyramid

Anonymous — Tue, 23 Feb 2016 05:26:45 GMT

For better understanding check this as well?

https://community.qlik.com/thread/59055

https://community.qlik.com/blogs/qlikviewdesignblog/2015/02/16/set-analysis

http://www.learnqlickview.com/qlikview-set-analysis-basics/

Re: Population Pyramid

Chanty4u — Tue, 23 Feb 2016 05:36:10 GMT

PFA

Re: Population Pyramid

MarcoWedel — Tue, 23 Feb 2016 06:14:37 GMT

nice to see you posting again.

regards

Marco

Re: Population Pyramid

Tue, 23 Feb 2016 14:01:05 GMT

Thank you John

Re: Population Pyramid

johnw — Tue, 23 Feb 2016 16:44:38 GMT

Thanks! I'm still trying to find time in my schedule, but I do have the support of my employer for contributing here again. And I really should have talked about set analysis, as that was more the real question here. Thanks for doing so, balrajahlawat‌.

Re: Population Pyramid

johnw — Tue, 23 Feb 2016 16:51:14 GMT

The last expression has an easily-missed "&" in it to append the "%" rather than have it as part of the numeric format, so I believe it would show as 40.0% instead. Well, it looks like there's a missing ")", so that can be the source of some confusion, and what was really intended isn't entirely clear. I was thinking it belonged before the "&" since I think that would give the right answer, but if you put it after the end of the whole expression, then yeah, it would probably show the wrong answer, 4000.0%.