topic Heatmap shading across two dimensions in QlikView https://community.qlik.com/t5/QlikView/Heatmap-shading-across-two-dimensions/m-p/531634#M551198 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'm trying to create a heat map using two dimensions in a pivot table (with one dimension vertical and the other dragged up so it is horizontal). When applying the colorwizard to the background colour using the same expression as in the pivot table the shading works across the columns (the vertical dimension) but not across the rows as well.</P><P></P><P>This is seen in the attached where the count(ID) is 3 for VALUE2=5 and 2 for VALUE2=2 but they have the same colour.</P><P></P><P>How do I change the background colour expression so that 3 has a 'higher' colour than 2?</P><P></P><P>I've tried a few ways of expressing this but still can't get the relative shading across the two dimensions correct.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 15 Nov 2013 16:07:07 GMT 2013-11-15T16:07:07Z Heatmap shading across two dimensions https://community.qlik.com/t5/QlikView/Heatmap-shading-across-two-dimensions/m-p/531634#M551198 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'm trying to create a heat map using two dimensions in a pivot table (with one dimension vertical and the other dragged up so it is horizontal). When applying the colorwizard to the background colour using the same expression as in the pivot table the shading works across the columns (the vertical dimension) but not across the rows as well.</P><P></P><P>This is seen in the attached where the count(ID) is 3 for VALUE2=5 and 2 for VALUE2=2 but they have the same colour.</P><P></P><P>How do I change the background colour expression so that 3 has a 'higher' colour than 2?</P><P></P><P>I've tried a few ways of expressing this but still can't get the relative shading across the two dimensions correct.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 15 Nov 2013 16:07:07 GMT https://community.qlik.com/t5/QlikView/Heatmap-shading-across-two-dimensions/m-p/531634#M551198 2013-11-15T16:07:07Z Re: Heatmap shading across two dimensions https://community.qlik.com/t5/QlikView/Heatmap-shading-across-two-dimensions/m-p/531635#M551199 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Fri, 15 Nov 2013 18:36:27 GMT https://community.qlik.com/t5/QlikView/Heatmap-shading-across-two-dimensions/m-p/531635#M551199 Gysbert_Wassenaar 2013-11-15T18:36:27Z Re: Heatmap shading across two dimensions https://community.qlik.com/t5/QlikView/Heatmap-shading-across-two-dimensions/m-p/531636#M551200 <HTML><HEAD></HEAD><BODY><P>Thanks! Hadn't thought of using variables to aggregate across the dimensions...good idea!</P></BODY></HTML> Wed, 20 Nov 2013 17:33:28 GMT https://community.qlik.com/t5/QlikView/Heatmap-shading-across-two-dimensions/m-p/531636#M551200 2013-11-20T17:33:28Z