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
