color by expression - QlikSense - Page 2 - Qlik Community

Report Inappropriate Content · ‎2014-08-25

Hi all,

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 ?

Thanks!

K

reanfadyl · ‎2015-03-12

Nice work Steve! I tried this out and it worked fine. Pity picking a colour for a measure is so hard though.

Report Inappropriate Content · ‎2015-07-02

Hi Steve,

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.

Anonymous · ‎2015-07-03

Hi Joost,

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

jananireddy · ‎2015-12-21

Hi Steve,

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??

Anonymous · ‎2016-01-04

Hi Janani,

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.

jananireddy · ‎2016-01-04

Thanks Steve! I think this should help for now

Report Inappropriate Content · ‎2016-01-29

Great job!! Thanks a lot.

Tobias

jananireddy · ‎2016-02-01

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.

Anonymous · ‎2016-02-01

Good work! You might be interested in seeing how I extended this previously to create selectable color themes- Color Logic – loading multiple Color schemes

Report Inappropriate Content · ‎2016-02-23

Hello Steve,

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,

gal