Pivot Table Heat Map

spikenaylor1 — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to recreate a dashboard where at the moment I cannot get in touch with who developed it, and I can only access it through our Access Point.

The dashboard has a pivot table set up as a risk heat map, vertical Dimension is Impact is 5 to 1 down, Horizontal Dimension is Likelihood is 1 to 5 left to right

I have created this and works fine, but I cannot get the expression background colours to work.

The expression is:

Concat(Distinct [Risk ID],' ')

The expression Background Colour Definition is:

=only({1}if(isnull(R),White(),RGB(R,G,B)))

I cannot see the load script behind, so cannot see how the developer has achieved this,, I have tried a few of ideas found on interent like:

load * inline [

Type,R,G,B,ID

A,255,128,0,1

B,0,255,0,2

];

unsuccessfully,

Can anyone shed any ideas how to achieve the colouring as shown above with that colour definition

topic Pivot Table Heat Map in QlikView

Pivot Table Heat Map