Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

publication1
New Contributor

On a Bar Graph - How do I change the colour for each to my own selection?

Hi there I've tried a few ways to just do the most simple method to change a colour on a bar graph.

I have 3x (Heights) I want the first to be GREEN seconds to be ORANGE and third to be RED.

How is this not possible ?

1 Solution

Accepted Solutions

Re: On a Bar Graph - How do I change the colour for each to my own selection?

What ever you have applied in the chart, Let's assume

1) Sum(Sales)

2) Sum(Profit)

3) Sum(Loss)

Then, In the left side you can see "Master Items" --> Measures --> Create New --> Provide Sum(Sales) with color

vice versa for all three. Then, Use measure as what you created in the master item.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
7 Replies
Partner
Partner

Re: On a Bar Graph - How do I change the colour for each to my own selection?

Hi,

If you always have 3 bars, you can do it by using:

if(RowNo()=1,red(),if(RowNo()=2,blue(),green()))

That will always give for the first bar red then blue and then green.

Re: On a Bar Graph - How do I change the colour for each to my own selection?

What is 3x here?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
publication1
New Contributor

Re: On a Bar Graph - How do I change the colour for each to my own selection?

rrrrrrrrrrrr.PNG

Three values(heights)

publication1
New Contributor

Re: On a Bar Graph - How do I change the colour for each to my own selection?

Thanks, this did work and was a start however i need it like the attached image if you understand 🙂

 

eeeeeeeeeeeeeeeeeeeeeeeeeeeeeee.PNG

Re: On a Bar Graph - How do I change the colour for each to my own selection?

Create each measure in "Mater Measure" with color and they apply those measures in report. There is no other way until unless If you go with extensions.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
publication1
New Contributor

Re: On a Bar Graph - How do I change the colour for each to my own selection?

Okay im happy to try this, do you have a guide handy I can follow step by step please ?

Re: On a Bar Graph - How do I change the colour for each to my own selection?

What ever you have applied in the chart, Let's assume

1) Sum(Sales)

2) Sum(Profit)

3) Sum(Loss)

Then, In the left side you can see "Master Items" --> Measures --> Create New --> Provide Sum(Sales) with color

vice versa for all three. Then, Use measure as what you created in the master item.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)