topic Re: Colour Mix in QlikView

Colour Mix

Anonymous — Tue, 04 Feb 2014 10:47:27 GMT

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

Re: Colour Mix

ashwanin — Tue, 04 Feb 2014 10:58:46 GMT

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))

Re: Colour Mix

Anonymous — Tue, 04 Feb 2014 11:03:53 GMT

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

Re: Colour Mix

ashwanin — Tue, 04 Feb 2014 11:34:42 GMT

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.

Re: Colour Mix

Anonymous — Tue, 04 Feb 2014 11:56:44 GMT

I don't!!

Re: Colour Mix

Anonymous — Wed, 05 Feb 2014 11:14:36 GMT

Found a solution

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