topic Problem with hitmap in QlikView https://community.qlik.com/t5/QlikView/Problem-with-hitmap/m-p/221461#M74271 <HTML><HEAD></HEAD><BODY><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning></w:PunctuationKerning> <w:ValidateAgainstSchemas></w:ValidateAgainstSchemas> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables></w:BreakWrappedTables> <w:SnapToGridInCell></w:SnapToGridInCell> <w:WrapTextWithPunct></w:WrapTextWithPunct> <w:UseAsianBreakRules></w:UseAsianBreakRules> <w:DontGrowAutofit></w:DontGrowAutofit> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument></xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles></xml><![endif]--><!--[if gte mso 10]><style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Tableau Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}</style><![endif]--><P>Hello everyone,</P><P></P><P>I have small worries with a project. I carried out a hitmap (see image) with various colors.</P><P><A href="http://www.hiboox.fr/go/images/adulte/hitmap,d418b6a135ff8f280388d365ec631285.jpg.html" target="_blank"><IMG src="http://free0.hiboox.com/vignettes/1611/d418b6a135ff8f280388d365ec631285.jpg" /></A></P><P>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.</P><P>Would somebody have it an idea?</P></BODY></HTML> Tue, 19 Apr 2011 09:16:34 GMT 2011-04-19T09:16:34Z Problem with hitmap https://community.qlik.com/t5/QlikView/Problem-with-hitmap/m-p/221461#M74271 <HTML><HEAD></HEAD><BODY><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning></w:PunctuationKerning> <w:ValidateAgainstSchemas></w:ValidateAgainstSchemas> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables></w:BreakWrappedTables> <w:SnapToGridInCell></w:SnapToGridInCell> <w:WrapTextWithPunct></w:WrapTextWithPunct> <w:UseAsianBreakRules></w:UseAsianBreakRules> <w:DontGrowAutofit></w:DontGrowAutofit> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument></xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles></xml><![endif]--><!--[if gte mso 10]><style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Tableau Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}</style><![endif]--><P>Hello everyone,</P><P></P><P>I have small worries with a project. I carried out a hitmap (see image) with various colors.</P><P><A href="http://www.hiboox.fr/go/images/adulte/hitmap,d418b6a135ff8f280388d365ec631285.jpg.html" target="_blank"><IMG src="http://free0.hiboox.com/vignettes/1611/d418b6a135ff8f280388d365ec631285.jpg" /></A></P><P>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.</P><P>Would somebody have it an idea?</P></BODY></HTML> Tue, 19 Apr 2011 09:16:34 GMT https://community.qlik.com/t5/QlikView/Problem-with-hitmap/m-p/221461#M74271 2011-04-19T09:16:34Z Problem with hitmap https://community.qlik.com/t5/QlikView/Problem-with-hitmap/m-p/221462#M74272 <HTML><HEAD></HEAD><BODY><P>What is your formula for generating the heatmap colours?</P></BODY></HTML> Tue, 19 Apr 2011 09:48:12 GMT https://community.qlik.com/t5/QlikView/Problem-with-hitmap/m-p/221462#M74272 nathanfurby 2011-04-19T09:48:12Z Problem with hitmap https://community.qlik.com/t5/QlikView/Problem-with-hitmap/m-p/221463#M74273 <HTML><HEAD></HEAD><BODY><P>***</P></BODY></HTML> Tue, 19 Apr 2011 09:51:01 GMT https://community.qlik.com/t5/QlikView/Problem-with-hitmap/m-p/221463#M74273 2011-04-19T09:51:01Z Problem with hitmap https://community.qlik.com/t5/QlikView/Problem-with-hitmap/m-p/221464#M74274 <HTML><HEAD></HEAD><BODY><P>Hi Micro - sorry but have been very busy. And now I can't see your code.</P><P>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.</P><P></P></BODY></HTML> Wed, 20 Apr 2011 11:51:42 GMT https://community.qlik.com/t5/QlikView/Problem-with-hitmap/m-p/221464#M74274 nathanfurby 2011-04-20T11:51:42Z