Color graphic from dimension value without active selection

[delpherv]

Color graphic from value dimension without active selection

I have a bar chart with one dimension and one mesure that uses set anlyisis (see below)

count({1<Annee={'$(vAnneeActive)'}, bus_type = {'1'}>} bus_document_id)

I created a principal element with color for each value

And I would like color each value dimension with specific color but when I use color from dimension or I created an expression to calculate color from dimension value, it's not correct (see below)

dimension value that are not in active selection are not colored

I tried to create dimension taking account set anylisis like this, but it's not working

Aggr(ONLY({1<Annee={'$(vAnneeActive)'}, bus_type = {'1'}>}bus_action_rennomme),bus_action_rennomme)

How Can I do, to color each dimension value ?

[brunobertels]

Hi 

Try may be with a pick(match( fonctions : like this 

Color by Expression : 

pick(match(DIM,'Value1','Value2','Value3',...),color1,color2,color3,...) 

Regards 

[delpherv]

I tried but it's not working because they still take into account active selections.

[brunobertels]

Hi 

can you share you app.qvf or part of it so i can have a look to test some approach 

(without garanties of succes 🙂 )