topic Re: Custom color by expression for two different expressions in App Development

Custom color by expression for two different expressions

Allardata — Sat, 16 Nov 2024 11:11:01 GMT

I have a stacked bar-chart, with one dimension and two expressions.

Both expressions have a different meaning, but should be stacked to indicate a total.

By choosing color "Auto" or "Custom - Multicolored" I get the following visualization:

Almost perfect... Just not these default colors blue and purple-red-ish.

In the rest of my dashboard I use two custom colors for the meaning of these expressions, which I want to apply to this bar-chart.

Choosing color "Custom - By expression" allows me to create an expression to color. But I cannot seem to make a color-expression that results in a different color for the first and second expression. The single color-expressions seems to be applied on both expressions equally and I don't know if (and how) I can actually make an "IF"-statement to address them separately...

One of the attempts include an IF statement that checks for a dimension-value particular for one of the expressions.

Another attempt includes checking COLUMN(1), also didn't get that to work.

How can I use the custom color expression to set different colors for expressions?

Re: Custom color by expression for two different expressions

Gysbert_Wassenaar — Wed, 17 Jun 2015 18:05:42 GMT

One way is to add a dummy dimension. For example:

Dummy:

LOAD * INLINE [

Dummy

];

You can then use that Dummy as second dimension in your chart together with only one expression like pick(match(Dummy, 'A','B'), sum(Foo), sum(Bar))

And you can then use a pick match for the color expression too: pick(match(Dummy, 'A','B'), Green(), RGB(200,50,150))

ps. wear shades if you use that second rgb color

Re: Custom color by expression for two different expressions

Allardata — Wed, 24 Jun 2015 08:13:55 GMT

Smart! And useful as a workaround in some cases for sure.

Yet selecting that bar-chart will result in a field-selection on "Dummy", right? As well as the pop-up when doing a mouse-over.

Re: Custom color by expression for two different expressions

Gysbert_Wassenaar — Wed, 24 Jun 2015 15:59:42 GMT

You're right about the pop-up. So you might want to use another field name than Dummy. Something that better describes the measures represented by the values of the dummy dimension. Selecting a bar segment won't select the value in the Dummy dimension. See attached example.

Re: Custom color by expression for two different expressions

demonioazul — Fri, 11 Sep 2015 14:31:45 GMT

Hi!

I have a similar issue, but my graph is not stacked...

I used the Dummy in the Load Script provided by gwassenaar and it works ok (see the custom colours in my graph).

Problem is that Sense does not allow me to add an additional measure. The yellowish column should have other values (those from the measure I cannot add), not the same as the green one.

I am using a Dimension I created in the Master items (shown here are EA HP LP .... etc) in order to drill down (which btw uses the custom colours as well ) and the Dummy as Dimension as well - maybe due to the drill down dimension I cannot add more than one measure?

DummyAllWon:

LOAD * INLINE [

OpportunitiesAllWon

Sales Speed All Opps

Sales Speed Won Opps

];

pick(match([OpportunitiesAllWon],'Sales Speed All Opps','Sales Speed Won Opps'),

green(),

rgb(200,150,0)

)

Thanks...!!

Re: Custom color by expression for two different expressions

demonioazul — Fri, 11 Sep 2015 15:43:12 GMT

I switched for a non drill down Dimension and it does not allow me to add an additional measure

Re: Custom color by expression for two different expressions

abhaysingh — Fri, 20 Nov 2015 06:38:49 GMT

Hi Gysbert,

Suppose you have two two measures and one dimension in it than how can we achieve it?.

Re: Custom color by expression for two different expressions

Gysbert_Wassenaar — Fri, 20 Nov 2015 08:43:45 GMT

Suppose you have two two measures and one dimension in it than how can we achieve it?.

Can you explain what you mean with "two two measures"? The case of two measures and one dimension has been demonstrated above.

Re: Custom color by expression for two different expressions

abhaysingh — Fri, 20 Nov 2015 09:36:29 GMT

Hi,

Color Change in qs

i have posted the sample qvf here pls look once..

Re: Custom color by expression for two different expressions

reddy-s — Sat, 21 Nov 2015 01:01:20 GMT

Hi Allard,

I have answered the same question in this link : Re: How to use custom colours in a stacked bar chart with an attached QVF.

Hope this helps!

Thanks,

Sangram Reddy

Re: Custom color by expression for two different expressions

Allardata — Tue, 15 Dec 2015 08:06:34 GMT

Thanks for pointing to that other thread. Helpful!
Although it achieves the result, it's far from ideal when trying to use a consistent color for a certain country throughout the dashboard.

Re: Custom color by expression for two different expressions

vlad_komarov — Thu, 07 Jan 2016 23:52:21 GMT

Gysbert,

What solution would you suggest for Combo Chart (not a Bar Chart) case?

As far as I know CC are not allowing multiple dimensions (I am using QS 2.1.1)....

Regards,

Vladimir

Re: Custom color by expression for two different expressions

Gysbert_Wassenaar — Fri, 08 Jan 2016 16:59:02 GMT

Can you explain what you want to do in a combo chart with regard to colors? Preferably in a new discussion.

Re: Custom color by expression for two different expressions

vlad_komarov — Fri, 08 Jan 2016 18:45:16 GMT

I need to set different (non-standard or "suggested" by Qlik) colors for my measures...

I have 4: 2 Bars and 2 lines.

I've created a post trying to understand if I can use the same approach as above in Combo charts.. (Unable to add second dimension to a Combo chart)

Regards,

Re: Custom color by expression for two different expressions

adandreti — Thu, 25 Oct 2018 13:33:21 GMT

One way to achieve this is by creating a Master Item Measure for both of your measures. In creation of this measure you are able to select the color of your choice for each respective measure and these colors will stay consistent throughout your app if you have them displayed in multiple sheets.

Re: Custom color by expression for two different expressions

BmRoux — Tue, 29 Jun 2021 08:04:57 GMT

Hi,

This helped me a lot to achieve colour by expression but how can I set the colour according to a comparison between the 2 bars?

I have Actual vs Budget so my expression is

pick(match(only({<FISCAL_MONTH={"<=$(vMaxMonth)"}>}[ACTUAL/BUDGET]), 'Actual','Budget'),sum({<CODE_LVL8={'HBVERK'},FISCAL_MONTH={"<=$(vMaxMonth)"}>}ACTUAL*-1),
sum({<CODE_LVL8={'HBVERK'},FISCAL_MONTH={"<=$(vMaxMonth)"}>}BUDGET*-1))

I want the Actual bar to be LightRed() when it is less than budget?

Re: Custom color by expression for two different expressions

FlyingFrog — Fri, 13 Jan 2023 08:23:46 GMT

Why is this so darn complex in Qlik? 😤

Like c'mon, selecting by measure does not work straightforward. Selecting multi-color does not allow self selecting a color scheme. And doing by expression is far from straightforward too.

It should not be this complex.