If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
i am struggeling with a simple line chart. It shows revenue over month - so "Month" would be one dimension. It has two expressions. The one calculates revenue for the current year. The other calculates revenue for the previous year. All no problem.
What i want - and until now couldnt get to: I want the line representing the current year to have a specific color (lets say, red) and the line representing the previous year to have another specific color (lets say, gray).
Can anyone help and explain how this can be done in SENSE ?
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.
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.
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,