topic Possible bug in ColorMix Wizard? in QlikView https://community.qlik.com/t5/QlikView/Possible-bug-in-ColorMix-Wizard/m-p/463026#M172902 <HTML><HEAD></HEAD><BODY><P>I think I may have found a possible bug in the colormix wizard, where it is not assigning a background color to the last column in a pivot table.</P><P></P><P>I tested another background color scheme (not colormix1 or from the wizard) on a copy of the same table.</P><P></P><P>Has anyone encountered this issue before? Any thoughts on a fix?</P><P></P><P></P><P></P><P>Here is an image showing that column 5 is not being colored.</P><P></P><P><IMG __jive_id="42515" class="jive-image-thumbnail jive-image" onclick="" alt="Untitled.png" src="https://community.qlik.com/legacyfs/online/42515_Untitled.png" width="450" /></P><P>Here is the background color code from the broken table on the left</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13709849124407041" jivemacro_uid="_13709849124407041"><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13709849256456603" jivemacro_uid="_13709849256456603"><P>ColorMix1 ((1+Sign(2*(avg(Cust_TotalGrossAmt)-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))</P><P>/(RangeMax (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total)))-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))-1)</P><P>*Sqrt(Fabs((2*(avg(Cust_TotalGrossAmt)-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))</P><P>/(RangeMax (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total)))-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))-1))))/2, </P><P>ARGB(255, 248, 105, 107), ARGB(255, 99, 190, 132))</P></PRE> </PRE><P></P><P>Here is the code from the table on the right</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13709849998445894" jivemacro_uid="_13709849998445894"><P>=If(avg(Cust_TotalGrossAmt) &gt;= 10000,rgb(0,255,0),</P><P>rgb(255-ROUND(255 *(avg(Cust_TotalGrossAmt)/10000)),255 ,255-ROUND(255 *(avg(Cust_TotalGrossAmt)/10000)))) </P></PRE></BODY></HTML> Tue, 11 Jun 2013 21:10:49 GMT 2013-06-11T21:10:49Z Possible bug in ColorMix Wizard? https://community.qlik.com/t5/QlikView/Possible-bug-in-ColorMix-Wizard/m-p/463026#M172902 <HTML><HEAD></HEAD><BODY><P>I think I may have found a possible bug in the colormix wizard, where it is not assigning a background color to the last column in a pivot table.</P><P></P><P>I tested another background color scheme (not colormix1 or from the wizard) on a copy of the same table.</P><P></P><P>Has anyone encountered this issue before? Any thoughts on a fix?</P><P></P><P></P><P></P><P>Here is an image showing that column 5 is not being colored.</P><P></P><P><IMG __jive_id="42515" class="jive-image-thumbnail jive-image" onclick="" alt="Untitled.png" src="https://community.qlik.com/legacyfs/online/42515_Untitled.png" width="450" /></P><P>Here is the background color code from the broken table on the left</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13709849124407041" jivemacro_uid="_13709849124407041"><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13709849256456603" jivemacro_uid="_13709849256456603"><P>ColorMix1 ((1+Sign(2*(avg(Cust_TotalGrossAmt)-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))</P><P>/(RangeMax (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total)))-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))-1)</P><P>*Sqrt(Fabs((2*(avg(Cust_TotalGrossAmt)-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))</P><P>/(RangeMax (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total)))-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))-1))))/2, </P><P>ARGB(255, 248, 105, 107), ARGB(255, 99, 190, 132))</P></PRE> </PRE><P></P><P>Here is the code from the table on the right</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13709849998445894" jivemacro_uid="_13709849998445894"><P>=If(avg(Cust_TotalGrossAmt) &gt;= 10000,rgb(0,255,0),</P><P>rgb(255-ROUND(255 *(avg(Cust_TotalGrossAmt)/10000)),255 ,255-ROUND(255 *(avg(Cust_TotalGrossAmt)/10000)))) </P></PRE></BODY></HTML> Tue, 11 Jun 2013 21:10:49 GMT https://community.qlik.com/t5/QlikView/Possible-bug-in-ColorMix-Wizard/m-p/463026#M172902 2013-06-11T21:10:49Z