topic Heat Map in QlikView

Heat Map

Wed, 24 Nov 2010 08:29:23 GMT

Is it possible to have a heat map in qlikview

Heat Map

Wed, 24 Nov 2010 10:01:37 GMT

Heatmap is not a default graph in QlikView. I guess that you should be able to create such a map as an extension in QV 10.

Heat Map

Wed, 24 Nov 2010 14:09:11 GMT

How to do that. Please provide steps for the same

Heat Map

johnw — Wed, 24 Nov 2010 21:42:50 GMT

Depends on what sort of heat map you're talking about. It's a pretty wide class of charts. Attached are a couple simple examples, though. These are just regular QlikView charts with background color expressions.

Heat Map

Thu, 25 Nov 2010 02:15:31 GMT

Mr. John Witherspoon's attachment is a good example of heat map but if the heat map your talking about has to deal with a map of

a certain place I think its not possible because you need to use layering or other technique..(this is just my opinion ) cause i'm only a newbie..

Heat Map

johnw — Mon, 29 Nov 2010 18:49:19 GMT


mOngkz wrote: if the heat map your talking about has to deal with a map of a certain place I think its not possible because you need to use layering or other technique

Right, not possible directly, but as you say you could use layering or some other technique. Here's an example of a layering approach. I have a pivot table with a background color expression to define my heat map. Then I stick the map on top of it, partially transparent so you can see the heat map colors beneath it. It needs some cleanup work, but it might be good enough for some applications once cleaned up.

I also tried using a scatter chart with an ARGB expression so that dots overlayed each other and built up. That might be better for some requirements, but didn't really look like a heat map, so I abandoned that approach.

There may also be other ways to handle it.

Heat Map

Tue, 30 Nov 2010 04:21:09 GMT

can you post an example here john??

Heat Map

johnw — Tue, 30 Nov 2010 18:29:01 GMT

My previous post has three different examples in it. Did you want an example of something else? Are you asking about the scatter chart approach? I can post an example, but like I said, it's not really a heat map. In brief, you just use a background color expression like argb(50,100,100,160), for instance. A single spot will be very light, but as they cover each other, the color builds up. I've even used a variable with a list box for the transparency before, so that when you have just a few points being plotted, you can make them dark, but when you have a hundred thousand points, you can make them all very transparent to better see the trends instead of one giant ball of color. Or you could calculate the transparency based on the number of points.

Heat Map

Wed, 07 Mar 2012 21:18:14 GMT

This is brilliant!

Heat Map

cesaraccardi — Thu, 08 Mar 2012 17:14:52 GMT

Hi! I found this topic... It shows how to create a heatmap using extension.. I've found very interesting and I'm using it in my applications... Credits to Brian Munz:

http://community.qlik.com/thread/45125

Re: Heat Map

Mon, 10 Dec 2012 15:52:18 GMT

GeoQlik supports the display of QlikView data as an heat map. You can see a demo at http://qonnections.geoqlik.com/GeoQlik/proxy/QvAjaxZfc/opendoc.htm?document=2%20-%20FEMA%20Disaster%20Analysis.qvw&host=QVS@aslw0026&anonymous=true

Re: Heat Map

Wed, 30 Apr 2014 14:16:25 GMT

Hello John,

how I can define both dimensions, one vertically and one horizontally...

for instance in your example with product and customer...

Thank you,

Best Regards,

Nasim

Re: Heat Map

Tue, 21 Oct 2014 14:32:10 GMT

Hi John,

Is there any way to use the first example (Profit by Customer / Product) and do the color coding based on an assessment by line?

Ex.: For EACH client, color code the "product figures" (red to green) with the ones most profitable?

the end result can have a figure -3 green, because in that specific client is the most profitable product...

tanks in advance

José Bagina

Re: Heat Map

Thu, 26 Jan 2017 11:36:55 GMT

John, nice use of log in the expression.

I tend to use ARGB(alpha, r, g, b) where alpha is the transparency range 0 - 255.

Taken the liberty to update your qvw

Re: Heat Map

fabio182 — Thu, 05 Oct 2017 20:47:56 GMT

Yes, it's posible