Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community,
I'm trying to build a heat map for [Calls] per hour. How can I apply a background color to my [Calls] if the number of calls can vary greatly? Could you suggest? Thanks This is what I have in Excel, now I have to implement this in Qlikview.
can you describe how the colors should be distributed over and adjusted to this great range?
Hi Marco, I don't want to hardcode the values, because each week could be different (sometimes total number for the whole weel is 1200, next week it could be just 200). Is it any way to apply IF statement for the color background based on percentage of total? Let's say use appropriate colors for the percentage ranges (0-10%,10-25%,25-50%,50-75%,75-100%.). Instead of using a single color with varying shade or a spectrum between two analogous colors to show intensity based on percentage of total.