Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
PhilippZiemer
Partner - Contributor III
Partner - Contributor III

Heatmap Formatting

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!

3 Replies
JonnyPoole
Employee
Employee

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

Capture.PNG.png

MarcoWedel

Hi,

maybe this helps:

Sorted Heatmap example

regards

Marco

Heat map example 3.JPG.jpg

maxgro
MVP
MVP