Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
Creator II
Creator II
‎2018-11-14 01:42 AM

Finding % share

Hi,

PFA

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

Regards,

Kishor

 

Labels (1)
Labels
t2.xlsx
724 Views
0 Likes
1 Solution

Accepted Solutions
PrashantSangle
MVP
MVP
‎2018-11-14 01:57 AM

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

719 Views
0 Likes
1 Reply
PrashantSangle
MVP
MVP
‎2018-11-14 01:57 AM

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 🙂
720 Views
0 Likes