Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
Thanks, this is exactly what I needed!