Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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))