Skip to main content
Announcements
Qlik Announces Qlik Talend Cloud and Qlik Answers: LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
spikenaylor1
Creator
Creator

Pivot Table Heat Map

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

Heat Map.jpg

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

0 Replies