I need to color differently some measures on Qlik Sense. I know that the only way to do that is creating a unique measure composed by a list of measures (ValueList function).
The formulas contained in the measures are characterized by the AGGR function.
The AGGR function doesn't work with the list of measures and the Qlik community suggests to avoid this conflict using AGGR(NODISTINCT).
Now the colors work but the values are wrong due to the aggregation duplicated ( in fact AGGR(NODISTINCT) creates a matrix where the result of the aggregation is duplicated for every different combination).
I tried to solve this problem using DISTINCT AGGR(NODISTINCT) but this function eliminates all the duplicates, even if these duplicated values were not the result of the duplication created by the AGGR(NO DISTINCT) but were equals from the beginning.
How can I mantain the two same values using DISTINCT AGGR(NODISTINCT)?
