topic Re: Heatmap Table/Chart? in QlikView

Heatmap Table/Chart?

Wed, 14 May 2014 12:39:53 GMT

I'd like to make a similar Heatmap view like the one in the QlikView Governance Dashboard Session Heatmap Aggregation by Hour.

Any thoughts how to do it? Is this something i can do with QV11 Objects? Does anyone have qvw example of something similar?

alexandros17 — Wed, 14 May 2014 12:45:15 GMT

The expression for the background color (and the same for the text color so it disappear) must be something like:

If (value >= val1 and value <= val2, rgb(10,10,10),

If (value >= val1 and value <= val2, rgb(20,20,20),

....

)

Where values for RGB functions are your colours gradations

crusader_ — Wed, 14 May 2014 12:48:56 GMT

Hi,

Look at this blog

Hope this helps

Kind regards,

Andrei Kaliahin

crusader_ — Wed, 14 May 2014 13:06:36 GMT

Hi,

Please check this article:

qlikfreak.wordpress.com/2014/03/09/heat-map/

Hope this helps

Kind regards,

Andrei Kaliahin

Wed, 14 May 2014 14:35:47 GMT

Thanks! Great article, helped me a lot.