Heat Map

[#1]

Is it possible to have a heat map in qlikview

[#2 · Accepted solution]

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.

[#3]

How to do that. Please provide steps for the same

[johnw]

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.

[#5]

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..

[johnw]

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.

[#7]

can you post an example here john??

[johnw]

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.

[#9]

This is brilliant!

[cesaraccardi]

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