color coded charts . is this possible?

[Anonymous]

Hi ,

My requirement is something like this.

I have 2 dimensions and 1 expression  and I need to display based on the increase number of messages at particular day in particular time as per the live data. And that should display a red color that indicates more messages.like a heat map.

I am attaching a sample of excel file.

Wondering if i can incorporate the same in qlik.

any help is really appreciated.

thanks.

[Anil_Babu_Samineni]

Create BG Color expression something like

if(Field1<=4,RGB(97,147,13), if(Field1>=5 and Field1<=8,RGB(246,158,22),Green()))