Solved: Finding % share - Qlik Community

kishorj1982 · ‎2018-11-14

Hi,

PFA

May I know how to find % share of population of each city within its country.

Regards,

Kishor

PrashantSangle · ‎2018-11-14

Use TOTAL keyword

sum(Population) / sum(total <state> Population)

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2018-11-14

Use TOTAL keyword

sum(Population) / sum(total <state> Population)

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂