topic Re: Help needed in creating Heatmap in QlikView

Help needed in creating Heatmap

Thu, 26 Mar 2015 21:36:33 GMT

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?

Re: Help needed in creating Heatmap

Gysbert_Wassenaar — Fri, 27 Mar 2015 09:45:06 GMT

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

Re: Help needed in creating Heatmap

Fri, 27 Mar 2015 18:55:14 GMT

Hi Gysbert,

Here is the sample data in excel.

Re: Help needed in creating Heatmap

Sat, 28 Mar 2015 06:40:23 GMT

You can try this in the Pivot Table

I am posting example file

And Check this link also

Heat Map | Qlik Freak

Re: Help needed in creating Heatmap

pokassov — Sat, 28 Mar 2015 14:40:54 GMT

Hi Adeel!

I used your Sample Data.

Check my result.

Re: Help needed in creating Heatmap

Wed, 01 Apr 2015 20:53:47 GMT

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