Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Grid Chart Heat Map

I've been trying to create a heat map using QV's grid chart. I'm having difficulty sorting it as I'd like. I want the top left corner to be populated with the worse offenders and the bottom right corner with the best. That is, the column with the lowest total average is farthest left and the row with the lowest total average is at the very top. This forum keeps throwing me an error when i try to upload a sample QVW so I'm including here some additional info:

Chart Type: Grid Chart

2 Dimensions: "KPI" and "Project"

1 Expression: "Score" calculated with this expression ((1 -(sum(Score)/sum(WorstScore)))* 100)

Tags (5)
2 Replies
Not applicable

Grid Chart Heat Map

any thoughts on sorting a grid chart along both axes?

MVP
MVP

Grid Chart Heat Map

Sort both X and Y by sum(Z) descending. Substitute your own dimensions and expressions. See attached.