Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 :
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-
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.
Can anyone advise or help me to solve this ?
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-
Extension seems not working in June 2019 version.
Is there any feasibility to achieve in native object ?
Can you please share sample file to test and make sure - You've explained outcome also from given sample file
Any help ...