topic Re: Heatmap Pivot Table in App Development

Heatmap Pivot Table

CarlyPharma — Sat, 16 Nov 2024 17:42:01 GMT

Hello,

Does anyone have a good solution to represent a heatmap in QlikSense?

Following the advice here (https://community.qlik.com/t5/New-to-QlikView/Working-with-a-Risk-Map/td-p/1112151) I have created some heatmaps using a pivot table. The result is nice, the only issue is that when filters are applied, rows without values disappear, destroying the square shape.

Is there any way to maintain the rows/form?

before filtering:

after filtering:

Thank you for any suggestions!

Carly

Re: Heatmap Pivot Table

BjoernLangeLeapLytics — Wed, 27 Jan 2021 05:10:39 GMT

Dear Carly,

I think, that we have something, which is helpful. LeapLytics provides advanved extensions for project reporting in QlikSense. You can find more on: www.leaplytics.de or you can try our free extensions in Qlik Garden Branch:

https://developer.qlik.com/garden/5fd6531adae7960011eb30ec

https://developer.qlik.com/garden/5fa315a3495c3700115f38b5

I am happy to hear from you and if you have any questions, just send me a message or mail (bjoern.lange@leaplytics.de)

Regards,

Bjoern

Re: Heatmap Pivot Table

morenoju — Wed, 27 Jan 2021 17:42:44 GMT

Hi @CarlyPharma ,

I use the extension 2DimHeatmap (https://github.com/ralfbecher/QlikSense_Extension_2DimHeatmap) and to keep the rectangular format of it without cells disappearing I configure the measure as this:

if(Count(itemID)+0*count({1}itemID)>0,
Count(itemID)+0*count({1}itemID))

This means that if the count of the measure is greater than zero, the heatmap displays the count on the cell. If it's zero, a null (a dash) gets displayed.

I hope this helps.

Re: Heatmap Pivot Table

CarlyPharma — Thu, 22 Apr 2021 15:54:51 GMT

Hello,

I was able to find a simple solution without requesting the extension (as it is a difficult business process for me).

Measure:

Count ({1} Aggr ( Count ( CaseID ), Impact, Likelihood)) * Count(CaseID)

Thank you!

Carly