Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

stickman
New Contributor

Create Heatmap Table

Looking to get help on creating a heat map for a weekly view for each product.

I'm not sure how I can have the week # (from 1 to 52) placed on the top row and the products down the first column.

I've attached a sample picture of what I would like it to look like.

Can someone help me construct the table please?

Thank you

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Create Heatmap Table

You need to use as chart-type a pivot and there you could drag the column into a horizontal position - left click on the column-header and then dragging.

- Marcus

4 Replies
MVP & Luminary
MVP & Luminary

Re: Create Heatmap Table

Take a look here: The great heat chart

- Marcus

stickman
New Contributor

Re: Create Heatmap Table

Marcus, thank you for the quick reply.

When I add the Date dimension, it puts it down the column instead of across the row. Is there a fix to this? What am I doing wrong?

MVP & Luminary
MVP & Luminary

Re: Create Heatmap Table

You need to use as chart-type a pivot and there you could drag the column into a horizontal position - left click on the column-header and then dragging.

- Marcus

stickman
New Contributor

Re: Create Heatmap Table

Genius!