How to change measure's color dynamically in Combo chart based on selections in filter

[Rajkumar]

Hi All,

We have 1 dimension & 4 measures in combo chart.We want to color the 4 measure based on filter that user select.

The color should be unique for 4 measure that have 4 brands value .

Ex. If the user select Category filter , then the 4 measure  color should change accordingly .

Please advise us?

[RadovanOresky]

Hi,

If I understand correctly (and you are using Qlik Sense), you need to use the workaround with ValueList() function.

It's nicely described in this document : 

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Qlik-Sense-How-to-set-custom-colors-by...

Or this blog post :

https://community.qlik.com/t5/Qlik-Design-Blog/Use-Case-for-ValueList-Chart-Function/ba-p/1476008

For your case, the color for Measure 4 will be defined by a conditional expression.

Hope this helps.

-RADO-

[Rajkumar]

Hi ,

My first measure is bar and rest all measures are lines in chart, so I am not able add value list  and defined color.

[Rajkumar]

Can anyone advise or help me to solve this ?

[RadovanOresky]

Hi, I understand what you need now a bit better.

You could try a very complex IF expression for chart color, but I'm not sure if it would work.

If splitting the chart into two objects is not an option then I can only suggest the Picasso Designer extension.

https://developer.qlik.com/garden/5b2d55a67bf18d24af3956c5

It's much harder to set up but gives many more formatting possibilities.

-Rado-

[Rajkumar]

Extension seems not working in June 2019  version.

Is there any feasibility to achieve  in native object ?

[Anil_Babu_Samineni]

Can you please share sample file to test and make sure - You've explained outcome also from given sample file

[Rajkumar]

Any help ...