topic Coloring max and min values in PivotTable Qlik Sense in App Development https://community.qlik.com/t5/App-Development/Coloring-max-and-min-values-in-PivotTable-Qlik-Sense/m-p/1228251#M23951 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><SPAN style="color: #000000; font-family: Calibri, sans-serif; font-size: 15px;">I would like your help.</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Calibri, sans-serif; font-size: 15px;">I'm using Qlik Sense and it has a PivotTable.</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Calibri, sans-serif; font-size: 15px;">I would like to color the background of a column by putting the maximum values in red and the minimum in blue. But I need this done for each Product. </SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Calibri, sans-serif; font-size: 15px;">As 'lines' I have: Product and State</SPAN></P><P>As 'mesures' I have: Value</P><P></P><P>Product A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>FL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>TX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>Product B</P><P>FL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150</P><P>TX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 130</P><P>CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120</P><P></P><P><SPAN style="color: #000000; font-family: Calibri, sans-serif; font-size: 15px;">Could anyone tell me what formula should I put in Background Color Expression for Value measure?</SPAN></P><P></P><P>Thank you!</P><P></P><P>André</P></BODY></HTML> Mon, 20 Feb 2017 19:08:07 GMT 2017-02-20T19:08:07Z Coloring max and min values in PivotTable Qlik Sense https://community.qlik.com/t5/App-Development/Coloring-max-and-min-values-in-PivotTable-Qlik-Sense/m-p/1228251#M23951 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><SPAN style="color: #000000; font-family: Calibri, sans-serif; font-size: 15px;">I would like your help.</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Calibri, sans-serif; font-size: 15px;">I'm using Qlik Sense and it has a PivotTable.</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Calibri, sans-serif; font-size: 15px;">I would like to color the background of a column by putting the maximum values in red and the minimum in blue. But I need this done for each Product. </SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Calibri, sans-serif; font-size: 15px;">As 'lines' I have: Product and State</SPAN></P><P>As 'mesures' I have: Value</P><P></P><P>Product A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>FL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>TX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>Product B</P><P>FL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150</P><P>TX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 130</P><P>CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120</P><P></P><P><SPAN style="color: #000000; font-family: Calibri, sans-serif; font-size: 15px;">Could anyone tell me what formula should I put in Background Color Expression for Value measure?</SPAN></P><P></P><P>Thank you!</P><P></P><P>André</P></BODY></HTML> Mon, 20 Feb 2017 19:08:07 GMT https://community.qlik.com/t5/App-Development/Coloring-max-and-min-values-in-PivotTable-Qlik-Sense/m-p/1228251#M23951 2017-02-20T19:08:07Z