Colour Mix

[Anonymous]

Hi - I am using to the colour mix wizard on a pivot table.

The pivot has 2 dimensions - when I display the pivot with the two dimensions as rows (right hand side) I get the desired result.

When I display the pivot with rows and columns - I get a different result - I notice the formula is using a row count which I am guessing is the cause of this.

Any idea how to get solve this?

Nandy

[ashwanin]

HI Nandy,

Your formula is based on the range of values.ie your Profit  (Check formula pasted below)

Formula is working correct. e.g for customer product 1 has minmum value hence it reflects red and same reflected in both of your graphs.

if Your value came in a range than it show similar result, else you have two colours for min and max ie. Red and Green.

Hope it clears your doubt.

below formula is pasted :

ColorMix1 ((1+Sign(2*(sum(PROFIT)-RangeMin (top(total sum(PROFIT),1,NoOfRows(total))))/(RangeMax (top(total sum(PROFIT),1,NoOfRows(total)))-RangeMin (top(total sum(PROFIT),1,NoOfRows(total))))-1)*Sqrt(Fabs((2*(sum(PROFIT)-RangeMin (top(total sum(PROFIT),1,NoOfRows(total))))/(RangeMax (top(total sum(PROFIT),1,NoOfRows(total)))-RangeMin (top(total sum(PROFIT),1,NoOfRows(total))))-1))))/2, ARGB(255, 255, 0, 0), ARGB(255, 0, 255, 0))

[Anonymous]

Hi - My issue is on Customer 2, product A, it has a different colour depending on how the pivot is displayed.

I would like the colours to be as the second pivot, but displayed in the format in the first pivot.

Thanks

Nandy

[ashwanin]

Hi , I have changed your both the graphs and found that this is showing the same colour. Because it calculates the same as per the parameters you have set.

[Anonymous]

I don't!!

[Anonymous · Accepted solution]

Found a solution

http://community.qlik.com/message/422690#422690