GIS/Maps Analytics in QlikView is a very interesting topic and "Heat Maps" are one of the ways to display QlikVIew KPI indicators and to represent a density on a Geografic map (ex: population, deliveries, etc.)
QlikView customers and channel parners are interested in displaying their QlikView KPI indicators on Geographic maps but also sometimes on a Building Plan (ex: logistic warehouse, supermarket, hospital, etc).
Business Geografic has developed a mapping extension for QlikView (V9, V10, V11) namely "GeoQlik" and we have been a Technology Partner of QlikTech since 2006 starting with QlikView 8!
I hereby suggest you to have a look at our new mapping extension for QlikView 11 "SR1": GeoQlik v11.6:
Please find hereafter a few "Heat Maps" screenshots of GeoQlik V11.6 using WMS/TMS services to display QlikView KPIs:
Thanks and best regards,
@ Business Geografic
Does anybody know how to add the following Set Analysis to the solution provided by B.Sarcich?
You need to use TOTAL in your sums and then <Dimension> based on the level the dimension sits.
eg.On the County dimension put
=IF(SUM(TOTAL <County> [Spend Variance])<0, rgb(225,36,38), rgb(36,145,64))
This calculates across the whole dimension rather than just row that you have scrolled down to.