Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Heat Map - mix colors problem

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

1 Solution

Accepted Solutions

Re: Heat Map - mix colors problem

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))

4 Replies
Not applicable

Re: Heat Map - mix colors problem

Hi,

can anybody help me?

Thanks,

Inna

Re: Heat Map - mix colors problem

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))

Not applicable

Re: Heat Map - mix colors problem

hi,

it helped.

Thanks a lot.

Inna.

Re: Heat Map - mix colors problem

Not a problem

Community Browser