Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help needed in creating Heatmap

I need to replicate the following excel heatmap in qlikview.

The x-axis and y-axis are continuous days. I think the closest I can come in qlikview is by using a grid chart with colormix function. However, even to do that, I need to split the x-axis and y-axis into groups of days (like below <30, 30 to 60 days). Given that grid charts don't allow for a static step, is there a better way to create this heatmap?

1 Solution

Accepted Solutions
pokassov
Specialist
Specialist

Hi Adeel!

I used your Sample Data.

Check my result.

View solution in original post

5 Replies
Gysbert_Wassenaar

I think it's possible with a pivot table. Can you post some source data?


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

Here is the sample data in excel.

Not applicable
Author

Hi

You can try this in the Pivot Table

I am posting example file

And Check this link also

Heat Map | Qlik Freak

pokassov
Specialist
Specialist

Hi Adeel!

I used your Sample Data.

Check my result.

Not applicable
Author

@pokassov - Your solution worked like a charm. Thank you!