Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Possible bug in ColorMix Wizard?

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.

I tested another background color scheme (not colormix1 or from the wizard) on a copy of the same table.

Has anyone encountered this issue before? Any thoughts on a fix?

Here is an image showing that column 5 is not being colored.

Untitled.png

Here is the background color code from the broken table on the left

ColorMix1 ((1+Sign(2*(avg(Cust_TotalGrossAmt)-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))

/(RangeMax (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total)))-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))-1)

*Sqrt(Fabs((2*(avg(Cust_TotalGrossAmt)-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))

/(RangeMax (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total)))-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))-1))))/2,

ARGB(255, 248, 105, 107), ARGB(255, 99, 190, 132))

Here is the code from the table on the right

=If(avg(Cust_TotalGrossAmt) >= 10000,rgb(0,255,0),

rgb(255-ROUND(255 *(avg(Cust_TotalGrossAmt)/10000)),255 ,255-ROUND(255 *(avg(Cust_TotalGrossAmt)/10000))))

0 Replies