Discussion board where members can get started with Qlik Sense.
Nice work Steve! I tried this out and it worked fine. Pity picking a colour for a measure is so hard though.
Is this also possible for a combo chart? Because I can not create a second dimension in a combo chart, the Synthetic Dimension does not seem to be an option here.
You cannot apply this method to the combo chat - see Combo chart seperate colours by expression
You can adjust the colours by re-ordering the measures
Or play around adding empty measures
Is there a way to display legends for my chart when i use "color by expression" option in qlik sense.
How can i achieve it with the above illustration??
There is currently no Legend option for color by expression. I have seen apps where an image has been created to display the legend. This does give you the ability to customise the look.
Thanks Steve! I think this should help for now
Great job!! Thanks a lot.
By using a table i managed to show legends when color by expression was used.
My excel data has a column 'RGBVALUE' - this holds the RGB value against each row.
Good work! You might be interested in seeing how I extended this previously to create selectable color themes- Color Logic – loading multiple Color schemes
Further to your solution.
I used ValueList the way you said and it really worked .
The problem is when I do selection model of the month, for example, the specific month stay in the right color and the rest of the line becomes the color of the second line.
Do you have a solution for this?
Thanks a lot,