Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

paisleymike
New Contributor III

Combing Averages to show in map

Hello I currently have a xml map which shows different areas

But within these areas they are then separated down more

Area A has 1 place in it

Area B has 3 places in it

Area C has 2 places in it

When I try to colour it by an average value

Only Area A shows colour

That's because there is only one place within it

What kind of expression would allow all the places values to be combined so it can be shown on the map

If that is possible from making a dimension or measure please let me know

Thank you