topic Re: Custom color in combined chart in App Development

Custom color in combined chart

Vasiliy_Beshentsev — Wed, 31 Jan 2018 08:01:21 GMT

Hello, qlikers!

I got this chart:

and using this expr in color by measure:

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:

Help me someone please.

Re: Custom color in combined chart

jasonmomoa — Wed, 31 Jan 2018 11:36:33 GMT

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,

Re: Custom color in combined chart

Vasiliy_Beshentsev — Wed, 31 Jan 2018 13:30:08 GMT

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

Re: Custom color in combined chart

OmarBenSalem — Wed, 31 Jan 2018 14:11:36 GMT

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?

Re: Custom color in combined chart

jasonmomoa — Wed, 31 Jan 2018 14:16:35 GMT

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.

Re: Custom color in combined chart

OmarBenSalem — Wed, 31 Jan 2018 14:18:12 GMT

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

Re: Custom color in combined chart

Michael_Tarallo — Wed, 31 Jan 2018 14:35:14 GMT

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”.

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

Re: Custom color in combined chart

OmarBenSalem — Wed, 31 Jan 2018 14:38:58 GMT

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?

Re: Custom color in combined chart

Michael_Tarallo — Wed, 31 Jan 2018 14:51:00 GMT

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.

Re: Custom color in combined chart

Vasiliy_Beshentsev — Thu, 01 Feb 2018 07:53:40 GMT

hi, Mike!

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

Re: Custom color in combined chart

Vasiliy_Beshentsev — Mon, 05 Feb 2018 08:50:35 GMT

Hello, mto‌, so have you look at Feb 2018 release for this feature?

Re: Custom color in combined chart

Michael_Tarallo — Mon, 05 Feb 2018 14:03:44 GMT

Hi Guys - i just got an update from our viz guy - this is not possible yet. I have submitted it as a feature request in our system, but that does not guarantee that it will make it in a future release. HTH