topic Re: QlikView Heat Map in QlikView https://community.qlik.com/t5/QlikView/QlikView-Heat-Map/m-p/80874#M785690 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>For each expression or dimension, you can just expand it and write an if statement for the background colour</P></BODY></HTML> Mon, 12 Mar 2018 08:14:14 GMT Anonymous 2018-03-12T08:14:14Z QlikView Heat Map https://community.qlik.com/t5/QlikView/QlikView-Heat-Map/m-p/80873#M785689 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi,</SPAN></P><P>I have created a pivot table which has the following columns;</P><P></P><OL><LI>Product Line</LI><LI>OTS Target</LI><LI>Data Column's by Month</LI></OL><P></P><P>Each Product Line row has a target for measuring performance, which is the guiding factor for color coding for that specific row.</P><P></P><P>Example;</P><P>For Product Line - 6A, OTS Target is 9 days.</P><P>Now in that row cell data which is above 9 days need to be colored in 'Red' and cell data less than equal to 9 days need to be colored 'Green', while row cells which have no data should remain as is.</P><P></P><P><IMG alt="ScreenHunter_04 Mar. 09 17.38.jpg" class="jive-image image-1" src="/legacyfs/online/195858_ScreenHunter_04 Mar. 09 17.38.jpg" style="height: 183px; width: 620px;" /></P><P></P><P>Regards,</P><P>Dev</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/QlikView-Heat-Map/m-p/80873#M785689 Anonymous 2020-11-25T16:16:04Z Re: QlikView Heat Map https://community.qlik.com/t5/QlikView/QlikView-Heat-Map/m-p/80874#M785690 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>For each expression or dimension, you can just expand it and write an if statement for the background colour</P></BODY></HTML> Mon, 12 Mar 2018 08:14:14 GMT https://community.qlik.com/t5/QlikView/QlikView-Heat-Map/m-p/80874#M785690 Anonymous 2018-03-12T08:14:14Z Re: QlikView Heat Map https://community.qlik.com/t5/QlikView/QlikView-Heat-Map/m-p/80875#M785691 <HTML><HEAD></HEAD><BODY><P>go through this thread <A __default_attr="590598" __jive_macro_name="message" class="jive_macro jive_macro_message" href="https://community.qlik.com/"></A></P><P></P><P>Vikas</P></BODY></HTML> Mon, 12 Mar 2018 08:56:53 GMT https://community.qlik.com/t5/QlikView/QlikView-Heat-Map/m-p/80875#M785691 vikasmahajan 2018-03-12T08:56:53Z