Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

How to put multiple colors in single bar in a bar chart ? Like Sales 100-200 should be in Red,sales above 200 should be in Green

How to put multiple colors in single bar in a bar chart ? Like Sales 100-200 should be in Red,sales above 200 should be in Green

8 Replies
dfoster9
Valued Contributor

Re: How to put multiple colors in single bar in a bar chart ? Like Sales 100-200 should be in Red,sales above 200 should be in Green

Can you explain a bit more about what you are trying to achieve?

bismart
Contributor

Re: Re: How to put multiple colors in single bar in a bar chart ? Like Sales 100-200 should be in Red,sales above 200 should be in Green

Like this?

Not applicable

Re: How to put multiple colors in single bar in a bar chart ? Like Sales 100-200 should be in Red,sales above 200 should be in Green

Hi David

Thanks for your reply , I am trying to create a bar chart with country and sales . i am  trying to color the graph depending up on the sales .for example (sales between 100-200 must be in red and sales above the 200 must be  in green with in the same bar )

anbu1984
Honored Contributor III

Re: How to put multiple colors in single bar in a bar chart ? Like Sales 100-200 should be in Red,sales above 200 should be in Green

Set to below in Background colour definition of sales expression

if(sales >200, Green(),Red())

Not applicable

Re: How to put multiple colors in single bar in a bar chart ? Like Sales 100-200 should be in Red,sales above 200 should be in Green

No!!!! it's not workiing .i had tried before. what i need is it must be colored with in the same bar

anbu1984
Honored Contributor III

Re: How to put multiple colors in single bar in a bar chart ? Like Sales 100-200 should be in Red,sales above 200 should be in Green

can you post sample app

Not applicable

Re: How to put multiple colors in single bar in a bar chart ? Like Sales 100-200 should be in Red,sales above 200 should be in Green


hi  anbu cheliyan thanks for your reply ,


Here in year  2012 i have sales near to 300 and my requirement is in 2012 graph must be in red and green as condition stated earlier .Condition is  sales <100 must be in red and sales>100 should be green ).pic.png

anbu1984
Honored Contributor III

Re: Re: How to put multiple colors in single bar in a bar chart ? Like Sales 100-200 should be in Red,sales above 200 should be in Green

Check this