Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 (2)
7 Replies
Highlighted
Luminary
Luminary

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-

Highlighted
Creator
Creator

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.

 

 

Highlighted
Creator
Creator

Can anyone advise or help me to solve this ?

Highlighted
Luminary
Luminary

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-

Highlighted
Creator
Creator

 

Extension seems not working in June 2019  version.

Is there any feasibility to achieve  in native object ?

 

 

Highlighted

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

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)
Highlighted
Creator
Creator

Any help ...