Skip to main content

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
inmemoryofER
Contributor II
Contributor II

Function to pull value from group with max value

I have a ZIP code area layer on a map chart that I have colored by a count() of the residents in each ZIP code. I would like to set the range for the color gradient to be dynamic so that the "range maximum" changes as different filter selections are made. Ideally I would set the color range maximum to be equal to number of residents in the zip code with the most residents (or take a percentage of that). I think maybe this can be accomplished with set analysis, but I'm a bit new to Qlik Sense so any help would be appreciated!

Labels (2)
1 Solution

Accepted Solutions
rubenmarin

Hi, you can check values with a table, add ZIP, your expression and Max(TOTAL Aggr([YourExpression], ZipDimension)) and check if this last column has teh amx value on all the rows, if it works, that's what you need.

View solution in original post

2 Replies
rubenmarin

Hi, you can check values with a table, add ZIP, your expression and Max(TOTAL Aggr([YourExpression], ZipDimension)) and check if this last column has teh amx value on all the rows, if it works, that's what you need.

inmemoryofER
Contributor II
Contributor II
Author

Thanks, this is exactly what I needed!