Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RK121
Contributor III
Contributor III
‎2022-10-28 12:33 PM

Heatmap Qlikview

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.

RK121_0-1666974071187.png

 

364 Views
0 Likes
2 Replies
MarcoWedel
MVP
MVP
‎2022-10-28 05:36 PM

can you describe how the colors should be distributed over and adjusted to this great range?

344 Views
0 Likes
RK121
Contributor III
Contributor III
‎2022-10-31 11:09 AM
Author

In response to MarcoWedel

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.

304 Views
0 Likes