Discussion board where members can get started with Qlik Sense.
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 ?
For this i suggest create the another color code inline table for this and connect it with the main fact table.
Assume this example
Load * Inline [
You can use custom color also by using RGB() function.
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
What if I color code the original table itself. Will that work ?
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 ?
Please see this how-to document:
Qlik Sense: How to set custom colors by measure in a bar chart