topic Re: Heat Map - mix colors problem in QlikView

Heat Map - mix colors problem

Tue, 19 Jul 2016 07:42:29 GMT

Hello,

I have the following heat map please see attached.

Expression which i have is:

count({$<Incoming_Flag = {1}>}TXID)

in background I have the following color mix formula:

ColorMix1( Count ({<Incoming_Flag = {'1'}>} TXID)/(sum(total <Date> aggr(Count ({<Incoming_Flag = {'1'}>} TXID),Day,Hour)))

,rgb(255,255,255),rgb(150,0,0))

So,

why 11 tickets we got on the 13/07/2016 at 1:00 pm are so red, while 25 tickets we got on the 17/07/2016 at 11:00 am are much less red?

Please advise.

Thanks,

Inna

Re: Heat Map - mix colors problem

Tue, 19 Jul 2016 08:35:00 GMT

Hi,

can anybody help me?

Thanks,

Inna

Re: Heat Map - mix colors problem

sunny_talwar — Tue, 19 Jul 2016 10:14:36 GMT

How about if you try this:

ColorMix1(Count ({<Incoming_Flag = {'1'}>} TXID)/(Max(TOTAL <Date> Aggr(Count({<Incoming_Flag = {'1'}>} TXID), Day, Hour))), RGB(255,255,255), RGB(150,0,0))

Re: Heat Map - mix colors problem

Tue, 19 Jul 2016 10:18:19 GMT

hi,

it helped.

Thanks a lot.

Inna.

Re: Heat Map - mix colors problem

sunny_talwar — Tue, 19 Jul 2016 10:20:06 GMT

Not a problem