Color by measure (chose custom colors for each measure)

[#1]

I have an excel file with 4 columns

GEO - SALES - DISCOUNT - MARGIN

I have created a Bar chart with x axis (Dimension) as GEO and Y axis (3 measures) Sales, Discount, Margin.

Is there a way to pick custom colors for each measure instead of applying an expression ?

Is there an option to color by measure or value ?

If not how would I chose custom colors for each measure ?

[its_anandrjs]

Hi,

For this i suggest create the another color code inline table for this and connect it with the main fact table.

Assume this example

Ex:-

Load * Inline [

GEO,SALES,DISCOUNT,MARGIN

1,Red(),Yellow(),Blue()

2,Green(),Blue(),Yellow()

3,Blue(),Green(),Red()

4,Yellow(),Green(),Red()

];

You can use custom color also by using RGB() function.

Regards

Anand

[reanfadyl]

The thread below covers off a few of the methods possible.  I think the last one by Steve Street is pretty good.

color by expression - QlikSense

[#4]

What if I color code the original table itself. Will that work ?

[#5]

This is too cumbersome if it needs to be done for multiple charts.

Let me change the requirement - what if my original sheet has all the columns colored - the GEO column is green, Sales is red etc.

Can I use that somehow to influence the color of the bar chart i.e. color in bar chart for measure = background color for that column in original sheet ?

[ian_wilson]

Please see this how-to document:

Qlik Sense: How to set custom colors by measure in a bar chart