Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vasiliy_beshent
Contributor III

Custom color in combined chart

Hello, qlikers!

I got this chart:

1231у12у.png

and using this expr in color by measure:

ц4к3ц.png

So i want to get this point -> i want to color line of plan in RED color, but color by measure colors all measures fact and plan... And i want to color plan line in RED, fact in COLOR BY MEASURE! Like this:

1231у12у.png

Help me someone please.

11 Replies
jasonmomoa
Contributor

Re: Custom color in combined chart

Hi vasiliy_beshentsev‌,

One solution could be creating the red line as a Reference Line under Add-ons property. You'll need to tune your expression but at least you will be able to separate the area color coding with the line color coding.

I usually use this option to display analysis against targets (hence, the target is a straight line). But you can type in any expression to make it similar to your red line above.

Regards,

vasiliy_beshent
Contributor III

Re: Custom color in combined chart

Xavier Garcia написал(а):

One solution could be creating the red line as a Reference Line under Add-ons property.

This feature available only in bar charts, not in combined charts.

I'm already try to make this in bar charts with reference line with plan measure, but it won't draw this line. Looks like reference line add-on works only with scalar value.

Reference lines ‒ Qlik Sense

omarbensalem
Esteemed Contributor

Re: Custom color in combined chart

I don't think it's possible

mto‌, can u please add this feature? the possiblity to combine the way to color measures separately in the graphic charts? as it's the case in table and kpi charts?

jasonmomoa
Contributor

Re: Custom color in combined chart

According to the documentation you privded, you can type in any numerical expression as reference line.

You need to be careful, though, sometimes it won't draw if it doesn't fall within the current range of the measure axis.

omarbensalem
Esteemed Contributor

Re: Custom color in combined chart

you can't add a reference line in the case; a refrence line is an horizantal line

Employee
Employee

Re: Custom color in combined chart

Hi Omar - I added the ability to add a reference line to a combo chart to our ideation system.

In regards to color measures separate - here is what I know - I replied to a similar post earlier today - I will post it here too:

For the February release we’ve added the option in color by to color by currently used dimension/measure and using this setting you will then get back the gradient. The benefit of coloring by currently used dimension/measure is also that when a user has alternative data we can keep on coloring it by what dimension is being used. Like in a pie chart when you switch dimension we will also switch the dimension we color by.

ou could also say that we now have the option to color by “relative” data instead of “absolute”.


q.jpg


Hope this helps


When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Michael Tarallo (@mtarallo) | Twitter

omarbensalem
Esteemed Contributor

Re: Custom color in combined chart

Hi Mike and thanks for the quick reaction,

That's not the same thing; what we want to have is the possiblity to colour 2 measures in different ways:

I mean, sthing like coloring in the simple table; in which we can color each column seperately.

Won't this be possible in other charts? And with that, we can color the first measure red (as a master measure) and the second one by expression.

We also have this kind of capability in the kpi object in which we can color each measure apart..

Hope that was clear?

Employee
Employee

Re: Custom color in combined chart

Hi Omar - Let me look at my Feb 2018 release - from what I saw - I can color 2 different measures differently in a chart - I'll come back to you shortly.

vasiliy_beshent
Contributor III

Re: Custom color in combined chart

hi, Mike!

It's definitely what i want to do! I want to color each measure in different "color by expr"