9 Replies Latest reply: Nov 27, 2015 10:28 AM by Jonathan Poole

# combo chart color measures by expression

i'm using a combo chart to display two measures.  the two measure expressions are:

sum(if([Availability woMW Severity]='Major',1,0))

sum(if([Availability woMW Severity]='Minor',1,0))

the resulting graph is:

i need to assign a specific color to each line.  using the color by expression.  i tried a few iterations of the following, but it's not doing it for me.  any suggestions?

if("Availability woMW Severity"='Major',RGB(255,0,0),if("Availability woMW Severity"='Minor',RGB(255,165,0)))

is there a way to refer to a measure in an expression by using it's label, etc?  i.e. the two measures have labels "Major count" and "Minor count".  wondering if there's a function that allows something along the lines of if(MeasureLabel = "Major count",red,if(MeasureLabel = "Minor count",orange))

• ###### Re: chart color measures by expression

Not with 2 measures

BUT... you can add an extra dimension using a synthetic expression like this:

valuelist('Major SLA Violations Count','Minor SLA Violations Count')

Then remove both measures and create just one:

if(   valuelist('Major SLA Violations Count','Minor SLA Violations Count') = 'Major SLA Violations Count',

sum(if([Availability woMW Severity]='Major',1,0)),

if( valuelist('Major SLA Violations Count','Minor SLA Violations Count') = 'Minor SLA Violations Count',

sum(if([Availability woMW Severity]='Minor',1,0))

)

)

Then you can color by expression like this:

if(   valuelist('Major SLA Violations Count','Minor SLA Violations Count') = 'Major SLA Violations Count',

red() ,

if( valuelist('Major SLA Violations Count','Minor SLA Violations Count') = 'Minor SLA Violations Count',

green()

)

)

where red() and green() are valid color expressions in qlik

• ###### Re: chart color measures by expression

Thank you Jonathan, Sangram.

What you're suggesting works great for line chart, but unfortunately unless my understanding is incorrect, it does not work for combo charts.  combo charts do not allow multiple dimensions.  i need combo charts to display the data vs two different y-axis.  any idea how to implement a color measure by expression function for combo charts?

• ###### Re: chart color measures by expression

Hi Michal,

Its not possible to colour code a combo chart, the way its done in a line chart or a bar chart because of the dimension limit. As you cannot achieve this with a combo chart, I would prefer going for an extension or build one for your business requirement.

• ###### Re: chart color measures by expression

thank you for the reply, but i would prefer the functionality is added to qlik sense.  seems like something that would be useful across the board.  should be as simple as measure a = color x, measure b = color y, etc.

• ###### Re: chart color measures by expression

This functionality will be added soon,  just not.right now.

• ###### Re: chart color measures by expression

awsome.  thank you jonathan.

• ###### Re: combo chart color measures by expression

Hi Jonathan, and soon is really when ? Next release ? I know , it's commercial confidential, but as we use QlikSense more and more especially on the Enterprise side, there are so many features (us QlikView dev types) are used to that we are being asked to reproduce in QlikSense only to see disappointment in the requester's demeanor  when they are told pretty much that it's not available in QS or an extension.

A tad embarrassing when a power user says "Look I can do this easily in Excel (brr shiver) or Tableau etc" how does one reply besides the standard "Oh hopefully the next version will solve it"

Yes QS has a little way to go as far as competitive maturity is concerned, but users/developers want it sooner than later

Cheers

Paul

• ###### Re: combo chart color measures by expression

Thanks. i shared the feedback. Its not next month but is coming.

You did not find an extension to do this ?

• ###### Re: chart color measures by expression

Hi Michal,

For an example on how to achieve this as Johathan mentioned check the attached QVF.

Hope this helps!

-Sangram