Discussion board where members can get started with QlikView.
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?
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.
View solution in original post
Take a look here: The great heat chart
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?