topic Colormix in heat map in QlikView

Colormix in heat map

sifatnabil — Fri, 20 Jan 2017 13:54:08 GMT

Hi all,

I made a cross table by using 2 dimensions (SessionID and Customer) and dragging SessionID to the top to create a "heat map". I used a dummy expression like ='x'. In the expression background colour, I'm using:

=ColorMix1(sum(Sales)/max(aggr(sum(Sales),SessionID,Customer)),white(),rgb(0,70,140))

But this doesn't show the correct colours. How can I amend ColorMix1() such that it takes the highest sum(Sales) of a Customer from the SessionIDs it participated in as the maximum value? This way, the heat map can show customer sales performance on a session by session basis. Thanks.

Re: Colormix in heat map

vkozlov — Fri, 20 Jan 2017 14:18:28 GMT

Try to use this example

Re: Colormix in heat map

sifatnabil — Fri, 20 Jan 2017 14:50:09 GMT

Hi vkozlov‌, I was actually using this example. But how can I make it such that the max value is the max within a single month? e.g. a max for January, February, March, etc. This example has a global max value for the entire data set.