aggr used in colormix2, wrong order

[#1]

Hello qlikview community,

I am trying to set the color in a pivot table using the colormix2 function.

The formula I am using to interpolate is, (pos-neg)/(pos+neg+neu), it will be between -1 and 1.

The problem is that I get an inconsistent value, I am using variables and each variable is defined like this:

subfield(Concat(TOTAL <topicName, itemName> aggr(Count(emotion),topicName,itemName,emotion),' '), ' ', FieldIndex('emotion','pos'))

It seems that aggr messes up the order of the fields.

Please someone help me fix this, see the attached file.

Best Regards

Anders