topic Re: Heatmap Formatting in QlikView

Heatmap Formatting

PhilippZiemer — Fri, 28 Nov 2014 13:29:56 GMT

I try to achieve a nice heatmap, where I have the Time dimension on the x-axis and the Object ID on the y-axis. I found a similar solution but cannot access the code:

I tried this using pivot-table but could not get the timeline to the bottom nor could I just display every second step. If I try it by using a bar-char I cannot get the second expression to the y-axis. Any ideas how I can achieven this exact solution?

Thanks!

Re: Heatmap Formatting

JonnyPoole — Fri, 28 Nov 2014 14:59:11 GMT

you can use round() or perhaps class() to bucket the time segments . Not sure why it doesn't extend to all dates.. i'd have to see the QVW sample.

As far as samples go, the governance dashboard has a similar pivot table that provides a heat map to show when concurrency on the system gets high vs low.

Instead of date you would use minute but perhaps keep the hour calc.

Its a free utility on http://market.qlik.com so you can download it and view the code / QVW

Re: Heatmap Formatting

MarcoWedel — Fri, 28 Nov 2014 15:24:04 GMT

Hi,

maybe this helps:

Sorted Heatmap example

regards

Marco

Re: Heatmap Formatting

maxgro — Fri, 28 Nov 2014 18:45:57 GMT

maybe here

Heat Map | Qlik Freak