aggr used in colormix2, wrong order

Wed, 02 Mar 2011 14:17:41 GMT

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

topic aggr used in colormix2, wrong order in QlikView