Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

reanfadyl
Contributor

Re: color by expression - QlikSense

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

Not applicable

Re: color by expression - QlikSense

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.

Highlighted
ses
Contributor

Re: color by expression - QlikSense

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

2014lightbars.JPG

2014darkbars.JPG

Or play around adding empty measures

2014custom.JPG

jananireddy
Contributor

Re: color by expression - QlikSense

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

ses
Contributor

Re: color by expression - QlikSense

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.

LegendCustom.PNG

jananireddy
Contributor

Re: color by expression - QlikSense

Thanks Steve! I think this should help for now

Not applicable

Re: color by expression - QlikSense

Great job!! Thanks a lot.

Tobias

jananireddy
Contributor

Re: color by expression - QlikSense

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. example.png

ses
Contributor

Re: color by expression - QlikSense

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

Not applicable

Re: color by expression - QlikSense

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

Community Browser