topic Risk Heatmap in App Development

Risk Heatmap

CarlyPharma — Thu, 22 Apr 2021 15:52:22 GMT

Hello,

I am looking for a solution (without using a Qlik Branch extension) to create Risk Heatmaps. I have managed to develop a tool using a pivot table, which dispays the total counts of risks in each grid section.

Measure:

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

I would now like to display the response progress for an individual risk, which shows three locations on the grid. E.g.

Is it possible to display the three points (could be X/0 instead of dots etc). Can someone help me with the formula?

Or does anyone have any better solutions for displaying risk management data?

Thank you for your help!

Carly

Re: Risk Heatmap

Dalton_Ruer — Thu, 22 Apr 2021 18:23:21 GMT

Depending on what version of Qlik Sense you are using, there is an actual Heatmap chart available in the Qlik Visualization bundle so you don't have to use a 3rd party extension. It will not allow you to overlay points on it.

As far fetched as it may seem you could use a custom map with the 16 cells. It won't display the counts, but would color just like a Heatmap, and you could then have a point layer and a line layer.

Re: Risk Heatmap

CarlyPharma — Wed, 05 May 2021 13:35:04 GMT

Hello,

Unfortunately I am not looking for a traditional heatmap which is coloured based on the count. It needs to be coloured based on the grid position and just display the count.

Thank you,

Carly

Re: Risk Heatmap

eddie_wagt — Wed, 05 May 2021 14:13:16 GMT

Maybe you could use the custom map with custom background?

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/Map/map-backgroundimage-example.htm

Re: Risk Heatmap

Syahfira_Zakaria — Mon, 02 Oct 2023 18:13:31 GMT

Hi Carly,

May I know how you managed to make the background color on the pivot table ?

It would be helpful as I need to build the risk heatmap for my team.

Thank you very much.