Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi
Try may be with a pick(match( fonctions : like this
Color by Expression :
pick(match(DIM,'Value1','Value2','Value3',...),color1,color2,color3,...)
Regards
I tried but it's not working because they still take into account active selections.
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 🙂 )