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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need Help with Set Analysis

Dear All,

I have 2 tables : 1 is the ciity table contains City, State_ID , Population, GRP on City Level

2 is the State table.

Then the final pivot table I have to make is shown as :

State, GRP on State level,

To Calculate the GRP on State Level - I have to use the set analysis which I am no master of.

GRP on State Level= (GRP on City Level * Population on City level) / Total Population on State Level)

Total Population on State Level= Total Population on City 1+2+... for every citry belong in that state.

Any help will be appreciated.

Thanks

10 Replies
Not applicable
Author

Hi Senjaya,

I've made a second load because your example was based on an "In line" table, so I couldn't make the concatenate between the two fields, you can do it in the original charge sentence.

Best regards.