Population Pyramid

[#1]

Can anyone explains to me what those expression mean?

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

[johnw]

1. Sum of female population
2. Negative sum of male population
3. Percentage of population that is female
4. 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.

[HirisH_V7]

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 !

[Anonymous]

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/

[Chanty4u]

hi

PFA

[MarcoWedel]

nice to see you posting again.

regards

Marco

[#7]

Thank you John

[johnw]

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

[johnw]

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