Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggr used in colormix2, wrong order

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

0 Replies