Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Heat Map

Is it possible to have a heat map in qlikview

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

14 Replies
Not applicable
Author

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.

Not applicable
Author

How to do that. Please provide steps for the same

johnw
Champion III
Champion III

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.

Not applicable
Author

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 Smile ) cause i'm only a newbie.. Big Smile

johnw
Champion III
Champion III


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.

Not applicable
Author

can you post an example here john??

johnw
Champion III
Champion III

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.

Not applicable
Author

This is brilliant!

cesaraccardi
Specialist
Specialist

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