Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Problem with hitmap

Hello everyone,

I have small worries with a project. I carried out a hitmap (see image) with various colors.

One has just asked me to make a graph or table which could say how much square of each color there is in my hitmap.

Would somebody have it an idea?

3 Replies
Highlighted
nathanfurby
Valued Contributor

Problem with hitmap

What is your formula for generating the heatmap colours?

Highlighted
Not applicable

Problem with hitmap

***

Highlighted
nathanfurby
Valued Contributor

Problem with hitmap

Hi Micro - sorry but have been very busy. And now I can't see your code.

From what I remember you had about 7 groupings that seemed quite straight forward to calculate. I wouldn't know if it was possible without looking at your data model, but could you calculate which group each value belonged to on load? You could then sum up by that group to get the numbers and use a mapping for the background colours.