Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Santosh
New 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
Labels (2)
1 Solution

Accepted Solutions
agni_gold
Valued Contributor II

Re: % share of population of each city within its country

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

1 Reply
agni_gold
Valued Contributor II

Re: % share of population of each city within its country

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