Help needed in creating Heatmap

[#1]

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?

[Gysbert_Wassenaar]

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

[#3]

Hi Gysbert,

Here is the sample data in excel.

[#4]

Hi

You can try this in the Pivot Table

I am posting example file

And Check this link also

Heat Map | Qlik Freak

[pokassov · Accepted solution]

Hi Adeel!

I used your Sample Data.

Check my result.

[#6]

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