topic paint values ​​that deviate from the average in QlikView https://community.qlik.com/t5/QlikView/paint-values-that-deviate-from-the-average/m-p/3854#M561 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Hello everyone,<BR />I have a pivoting table where two dimensions are presented (day and table) and a metric (average amount of data). It is possible to paint those cells that are below 20% of the average and above 20% of the average. Attachment. Thanks for your support</SPAN></P></BODY></HTML> Fri, 19 Jan 2018 22:59:43 GMT fabio182 2018-01-19T22:59:43Z paint values ​​that deviate from the average https://community.qlik.com/t5/QlikView/paint-values-that-deviate-from-the-average/m-p/3854#M561 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Hello everyone,<BR />I have a pivoting table where two dimensions are presented (day and table) and a metric (average amount of data). It is possible to paint those cells that are below 20% of the average and above 20% of the average. Attachment. Thanks for your support</SPAN></P></BODY></HTML> Fri, 19 Jan 2018 22:59:43 GMT https://community.qlik.com/t5/QlikView/paint-values-that-deviate-from-the-average/m-p/3854#M561 fabio182 2018-01-19T22:59:43Z Re: paint values ​​that deviate from the average https://community.qlik.com/t5/QlikView/paint-values-that-deviate-from-the-average/m-p/3855#M562 <HTML><HEAD></HEAD><BODY><P>Maybe this:</P><P></P><P>If( Avg(ExtractRowCnt) / Avg(TOTAL &lt;NOMBRE_TABLA&gt; ExtractRowCnt) &gt;= 1.2 OR Avg(ExtractRowCnt) / Avg(TOTAL &lt;NOMBRE_TABLA&gt; ExtractRowCnt) &lt;=0.2, Green(50) )</P><P></P><P><IMG alt="2018-01-20 00_55_28-QlikView x64 - [C__Users_Petter_Downloads_Monitoreo Tablas SQL_Server.qvw_].png" class="jive-image image-1" src="/legacyfs/online/190752_2018-01-20 00_55_28-QlikView x64 - [C__Users_Petter_Downloads_Monitoreo Tablas SQL_Server.qvw_].png" style="height: 117px; width: 620px;" /></P></BODY></HTML> Fri, 19 Jan 2018 23:57:06 GMT https://community.qlik.com/t5/QlikView/paint-values-that-deviate-from-the-average/m-p/3855#M562 petter 2018-01-19T23:57:06Z Re: paint values ​​that deviate from the average https://community.qlik.com/t5/QlikView/paint-values-that-deviate-from-the-average/m-p/3856#M563 <HTML><HEAD></HEAD><BODY><P>Thank you so much Petter. </P></BODY></HTML> Mon, 22 Jan 2018 19:08:37 GMT https://community.qlik.com/t5/QlikView/paint-values-that-deviate-from-the-average/m-p/3856#M563 fabio182 2018-01-22T19:08:37Z