Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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
Valued Contributor

Re: Help needed in creating Heatmap

Hi Adeel!

I used your Sample Data.

Check my result.

View solution in original post

5 Replies
MVP & Luminary
MVP & Luminary

Re: Help needed in creating Heatmap

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


talk is cheap, supply exceeds demand
Not applicable

Re: Help needed in creating Heatmap

Hi Gysbert,

Here is the sample data in excel.

Not applicable

Re: Help needed in creating Heatmap

Hi

You can try this in the Pivot Table

I am posting example file

And Check this link also

Heat Map | Qlik Freak

pokassov
Valued Contributor

Re: Help needed in creating Heatmap

Hi Adeel!

I used your Sample Data.

Check my result.

View solution in original post

Highlighted
Not applicable

Re: Help needed in creating Heatmap

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