topic Re: Coloring Sense Maps in App Development

Coloring Qlik Sense Maps

prpranav — Thu, 08 Aug 2019 06:01:49 GMT

Hey everyone!

I'm working with state voter data, and I'm trying to color each county of a state map either blue or red (Democrats or Republicans) depending on which the party won the county. I have all the data organized in one central table.

The data table lists number of votes the candidate won in each precinct (subset of county). A preview of the table is attached below.

In the color by expression, I tried :

if(FirstSortedValue( [Party], -aggr( sum([Candidate Votes]), [Candidate])) = 'Democratic Party'
, blue()
,if(FirstSortedValue( [Party], -aggr( sum([Candidate Votes]), [Candidate])) = 'Republican Party'
,red()))

but it returns a map of the counties with only one county colored (a picture is attached below).

I believe it is adding up all the votes in all counties and only returning one value for the winning party, but I'm not sure how to solve it. Any help would be appreciated.

Thank you!

Re: Coloring Sense Maps

Lisa_P — Thu, 08 Aug 2019 05:57:13 GMT

A simpler way to do colors is to create a Master dimension for Party and customize the colors for each Party value in the Master item. Then you can determine the party with the most votes and color by it.

Re: Coloring Sense Maps

prpranav — Thu, 08 Aug 2019 06:35:37 GMT

Thank you so much!

I created the Master Dimension for [Party] and assigned colored for each value, but where do I put the calculation for the party with the highest votes and color each county with it?

Also, is there another way to do the calculation, because I think the firstsortedvalue is doing the entire calculation for the state at once instead of per county?

Re: Coloring Sense Maps

Lisa_P — Thu, 08 Aug 2019 23:51:26 GMT

Actually, my first solution is not enough. You are right, you need that expression, but, this is how it should look:

if(FirstSortedValue( [Party], -aggr( sum([Candidate Votes]), [Candidate], Party)) = 'Democratic Party'
, blue()
,if(FirstSortedValue( [Party], -aggr( sum([Candidate Votes]), [Candidate], Party)) = 'Republican Party'
,red()))

Re: Coloring Sense Maps

prpranav — Fri, 09 Aug 2019 07:08:41 GMT

This is still resulting the same result

Is there another way to make the calculation?