Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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

Not applicable

Re: Help needed in creating Heatmap

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