Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Color by measure (chose custom colors for each measure)

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 ?

5 Replies

Re: Color by measure (chose custom colors for each measure)

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
Contributor

Re: Color by measure (chose custom colors for each measure)

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

Not applicable

Re: Color by measure (chose custom colors for each measure)

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

Not applicable

Re: Color by measure (chose custom colors for each measure)

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 ?

Employee
Employee

Re: Color by measure (chose custom colors for each measure)

Community Browser