Color 'Others' part by expression (Pie Chart)

[TT]

Hello Qlik Community,

Hope you are all fine !

I want to color 'other' part in a Pie chart by an expression which detects in which category my customer is. The category depends on the partner selected.

It seems that 'Others = Autres' cannot be in a specific color with an expression.

Have you got any ideas on this subject please ?

Regards,

T.T

[vinieme12 · Accepted solution]

instead of using field limitation = 10, use a calculated dimension

example

Dimension = 

if(aggr(rank(sum(MeasureField),4,2), YourDimension) <=10 , YourDimension , 'Others')

In Colors > choose Color by Expression

= if(Rowno()=11, red(), yellow())