Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajkumar
Creator
Creator

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

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?

 

 

 

Labels (1)
  • Chart

7 Replies
RadovanOresky
Partner Ambassador
Partner Ambassador

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
Creator
Creator
Author

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
Creator
Creator
Author

Can anyone advise or help me to solve this ?

RadovanOresky
Partner Ambassador
Partner Ambassador

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
Creator
Creator
Author

 

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Rajkumar
Creator
Creator
Author

Any help ...