Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Santosh
Contributor III
Contributor III

% share of population of each city within its country

Hi All,

How do i find % share of population of each city within its country.

 

CountryStateCityPopulation
IndiaMaharashtraPune      4,820,262
IndiaMaharashtraMumbai      1,418,336
IndiaMaharashtraNagpur      7,490,235
IndiaKarnatakaBengaluru      3,354,260
IndiaTamil NaduChennai      9,547,939
Japan HonshuTokyo          837,547
JapanHokkaidoSapporo      3,817,240
JapanKyushuKitakyushu          660,254
GermanyBavariaMunich      1,207,788
GermanyBerlinBerlin      3,747,035
1 Solution

Accepted Solutions
agni_gold
Specialist III
Specialist III

(sum(Population)/sum(TOTAL<Country> Population))

View solution in original post

1 Reply
agni_gold
Specialist III
Specialist III

(sum(Population)/sum(TOTAL<Country> Population))