Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
CarlyPharma
Contributor II
Contributor II

Heatmap Pivot Table

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:

Uploaded image: before filtering. image.png

 

after filtering:

Thank you for any suggestions!

Carly

Labels (3)
1 Solution

Accepted Solutions
CarlyPharma
Contributor II
Contributor II
Author

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)

CarlyPharma_0-1619106824067.jpeg

Thank you!

Carly 

View solution in original post

3 Replies
BjoernLangeLeapLytics
Contributor III
Contributor III

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

BjoernLangeLeapLytics_0-1611724139658.png

 

 

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

 

BjoernLangeLeapLytics_1-1611724139663.png

 

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

morenoju
Partner - Specialist
Partner - Specialist

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.

image.png

 

CarlyPharma
Contributor II
Contributor II
Author

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)

CarlyPharma_0-1619106824067.jpeg

Thank you!

Carly