topic Re: Best solution for Heatmap in QlikView https://community.qlik.com/t5/QlikView/Best-solution-for-Heatmap/m-p/74704#M789014 <HTML><HEAD></HEAD><BODY><P>Yes I have, but the problem in my case is that I have a lot of different columns with the data (P001, P002 etc). Most of the solutions I have seen pull the data from one single column</P></BODY></HTML> Thu, 08 Feb 2018 15:46:22 GMT felipe_oliveira 2018-02-08T15:46:22Z Best solution for Heatmap https://community.qlik.com/t5/QlikView/Best-solution-for-Heatmap/m-p/74702#M789012 <HTML><HEAD></HEAD><BODY><P>Hi Masters</P><P></P><P>I was wondering if it is possible to build heatmap in Qlikview using pivot table. Actually, if there is any other better way to do it I am fine with it.</P><P></P><P>my data base looks like this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Application_id</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Year</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Mont</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>P001</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG><STRONG style="color: #ffffff; text-align: center;">P002</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG><STRONG style="color: #ffffff; text-align: center;">P003</STRONG></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">P004</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">P005</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">P006</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">P007</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>P...</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">00001</TD><TD style="padding: 2px; text-align: center;">2017</TD><TD style="padding: 2px; text-align: center;">Jan</TD><TD style="padding: 2px; text-align: center;">Refer</TD><TD style="padding: 2px; text-align: center;">NULL</TD><TD style="padding: 2px; text-align: center;">Refer</TD><TD style="padding: 2px; text-align: center;">Accept</TD><TD style="padding: 2px; text-align: center;">Accept</TD><TD style="padding: 2px; text-align: center;">Refer</TD><TD style="padding: 2px; text-align: center;">Accept</TD><TD style="padding: 2px; text-align: center;">...</TD></TR><TR><TD style="padding: 2px; text-align: center;">00002</TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">2017</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Jan</SPAN></TD><TD style="padding: 2px; text-align: center;">Refer</TD><TD style="padding: 2px; text-align: center;">Accept</TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;">...</TD></TR><TR><TD style="padding: 2px; text-align: center;">00003</TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">2017</SPAN></TD><TD style="padding: 2px; text-align: center;">Feb</TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;">NULL</TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;">...</TD></TR><TR><TD style="padding: 2px; text-align: center;">00004</TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">2017</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Feb</SPAN></TD><TD style="padding: 2px; text-align: center;">Refer</TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;">...</TD></TR><TR><TD style="padding: 2px; text-align: center;">00005</TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">2017</SPAN></TD><TD style="padding: 2px; text-align: center;">Mar</TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;">NULL</TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;">...</TD></TR><TR><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">00006</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">2017</SPAN></TD><TD style="padding: 2px; text-align: center;">Apr</TD><TD style="padding: 2px; text-align: center;">NULL</TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;">NULL</TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;">NULL</TD><TD style="padding: 2px; text-align: center;">...</TD></TR><TR><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">00007</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">2017</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Apr</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Refer</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Accept</SPAN></TD><TD style="padding: 2px; text-align: center;">...</TD></TR><TR><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">00008</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">2017</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="text-align: center;">Apr</SPAN></TD><TD style="padding: 2px; text-align: center;">Refer</TD><TD style="padding: 2px; text-align: center;">Accept</TD><TD style="padding: 2px; text-align: center;">Accept</TD><TD style="padding: 2px; text-align: center;">Refer</TD><TD style="padding: 2px; text-align: center;">Accept</TD><TD style="padding: 2px; text-align: center;">Accept</TD><TD style="padding: 2px; text-align: center;">Accept</TD><TD style="padding: 2px; text-align: center;">...</TD></TR><TR><TD style="padding: 2px; text-align: center;">....</TD><TD style="padding: 2px; text-align: center;"></TD><TD style="padding: 2px; text-align: center;">...</TD><TD style="padding: 2px; text-align: center;">...</TD><TD style="padding: 2px; text-align: center;">...</TD><TD style="padding: 2px; text-align: center;">...</TD><TD style="padding: 2px; text-align: center;">...</TD><TD style="padding: 2px; text-align: center;">...</TD><TD style="padding: 2px; text-align: center;">...</TD><TD style="padding: 2px; text-align: center;">...</TD><TD style="padding: 2px; text-align: center;">...</TD></TR></TBODY></TABLE><P></P><P>I would like the heatmap to look like the attached file based on the count of "Refer" status</P><P></P><P>Please advise</P><P></P><P>Thanks!</P><P></P><P>Felipe</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Best-solution-for-Heatmap/m-p/74702#M789012 felipe_oliveira 2020-11-25T16:16:04Z Re: Best solution for Heatmap https://community.qlik.com/t5/QlikView/Best-solution-for-Heatmap/m-p/74703#M789013 <HTML><HEAD></HEAD><BODY><P>Have you see this already?</P><P><A href="https://qlikfreak.wordpress.com/2014/03/09/heat-map/" title="https://qlikfreak.wordpress.com/2014/03/09/heat-map/">Heat Map – Qlik Freak</A></P></BODY></HTML> Thu, 08 Feb 2018 15:28:57 GMT https://community.qlik.com/t5/QlikView/Best-solution-for-Heatmap/m-p/74703#M789013 sunny_talwar 2018-02-08T15:28:57Z Re: Best solution for Heatmap https://community.qlik.com/t5/QlikView/Best-solution-for-Heatmap/m-p/74704#M789014 <HTML><HEAD></HEAD><BODY><P>Yes I have, but the problem in my case is that I have a lot of different columns with the data (P001, P002 etc). Most of the solutions I have seen pull the data from one single column</P></BODY></HTML> Thu, 08 Feb 2018 15:46:22 GMT https://community.qlik.com/t5/QlikView/Best-solution-for-Heatmap/m-p/74704#M789014 felipe_oliveira 2018-02-08T15:46:22Z Re: Best solution for Heatmap https://community.qlik.com/t5/QlikView/Best-solution-for-Heatmap/m-p/74705#M789015 <HTML><HEAD></HEAD><BODY><P>It would be best to transform your data using <A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A></P></BODY></HTML> Thu, 08 Feb 2018 15:47:19 GMT https://community.qlik.com/t5/QlikView/Best-solution-for-Heatmap/m-p/74705#M789015 sunny_talwar 2018-02-08T15:47:19Z Re: Best solution for Heatmap https://community.qlik.com/t5/QlikView/Best-solution-for-Heatmap/m-p/74706#M789016 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny,</P><P></P><P>That worked perfectly! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 09 Feb 2018 15:11:14 GMT https://community.qlik.com/t5/QlikView/Best-solution-for-Heatmap/m-p/74706#M789016 felipe_oliveira 2018-02-09T15:11:14Z