Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
The thread below covers off a few of the methods possible. I think the last one by Steve Street is pretty good.
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