Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Colour Mix

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

1 Solution

Accepted Solutions
Contributor III
Contributor III

5 Replies
Specialist
Specialist

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

Contributor III
Contributor III

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

Specialist
Specialist

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.

Contributor III
Contributor III

I don't!!

qv screen shot .png

Contributor III
Contributor III