Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Heat Map

Is it possible to have a heat map in qlikview

1 Solution

Accepted Solutions
Not applicable

Heat Map

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.

14 Replies
Not applicable

Heat Map

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

Heat Map

How to do that. Please provide steps for the same

johnw
Not applicable

Heat Map

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

Heat Map

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
Not applicable

Heat Map


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

Heat Map

can you post an example here john??

johnw
Not applicable

Heat Map

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

Heat Map

This is brilliant!

cesaraccardi
Not applicable

Heat Map

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