Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
sifatnabil
Specialist
Specialist

Colormix in heat map

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.

2 Replies
vkozlov
Creator
Creator

Hi

Try to use this example

sifatnabil
Specialist
Specialist
Author

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.