Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
delpherv
Partner - Contributor
Partner - Contributor

Color graphic from dimension value without active selection

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

delpherv_0-1605691488944.png

 

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 ?

Labels (1)
3 Replies
brunobertels
Master
Master

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
Partner - Contributor
Partner - Contributor
Author

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

brunobertels
Master
Master

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 🙂