topic Re: Creating a Heat Map in QlikView

Creating a Heat Map

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

Hi Experts,

I am trying to create an Heat map with below requirement.

If 1<Sum(Measure)<=0.75 then the cell should be green

0.75<Sum(Measure)<=0.5 then the cell should be Yellow

0.5<Sum(Measure)<=0.1 then the cell should be Red

Other values should left out with Grey.

When I have tried to create I could see different colors are being applied in the cell background.

I have attached the data and Sample app. Could you please check and help me in getting this done.

Thanks

S k

tresB — Tue, 29 May 2018 11:03:15 GMT

Have you tried like:

=If( 1<Sum(Measure) and Sum(Measure)>=0.75, green(),

if(Sum(Measure)>=0.5, yellow(),

if(Sum(Measure)>=0.1, lightred())))

MarcoWedel — Tue, 29 May 2018 21:05:27 GMT

How is your expected result different from what you already have achieved?