topic Re: combo chart color measures by expression in App Development

combo chart color measures by expression

Wed, 25 Nov 2015 22:51:10 GMT

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

JonnyPoole — Thu, 26 Nov 2015 02:03:05 GMT

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

reddy-s — Thu, 26 Nov 2015 10:14:24 GMT

Hi Michal,

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

Hope this helps!

-Sangram

Re: chart color measures by expression

Thu, 26 Nov 2015 16:03:47 GMT

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

reddy-s — Thu, 26 Nov 2015 16:52:27 GMT

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

Thu, 26 Nov 2015 16:59:19 GMT

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

JonnyPoole — Thu, 26 Nov 2015 19:40:46 GMT

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

Re: chart color measures by expression

Thu, 26 Nov 2015 20:38:05 GMT

awsome. thank you jonathan.

Re: combo chart color measures by expression

paul_scotchford — Thu, 26 Nov 2015 21:07:08 GMT

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

JonnyPoole — Fri, 27 Nov 2015 15:28:01 GMT

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

You did not find an extension to do this ?

Re: combo chart color measures by expression

GregWP — Fri, 29 Nov 2019 05:06:18 GMT

hi, this would be really useful - is it available yet?

I have a line chart with two measures that show 'Actual LTD' & 'Target LTD' by month.

I simply want to gray-out those months prior to the current year-month selection. This part I can do ok, but I can't figure how to set a different colour for each measure in the 'else' part of the If statement?