Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mazacini
Contributor III

Red for negative, Green for Positive on Bar Charts in Qlik Sense

Hi.

Is there a way to display negative amounts as a red bar and positive amounts on a green bar in a bar chart in Qlik Sense?

Thanks

Joe

1 Solution

Accepted Solutions

Re: Red for negative, Green for Positive on Bar Charts in Qlik Sense

Like this?

Capture1.PNG

Use these settings (Images to Follow)

  • When on Edit Mode, click on Appearance
  • Select Colors and Legend
  • Change from Auto to Custom Colors
  • Use Expression from the drop down and use the following expression for your requirement
    • If(YourExpression > 0, Green(), Red()

Capture.PNG

I hope this will help.

Best,

Sunny

2 Replies

Re: Red for negative, Green for Positive on Bar Charts in Qlik Sense

Like this?

Capture1.PNG

Use these settings (Images to Follow)

  • When on Edit Mode, click on Appearance
  • Select Colors and Legend
  • Change from Auto to Custom Colors
  • Use Expression from the drop down and use the following expression for your requirement
    • If(YourExpression > 0, Green(), Red()

Capture.PNG

I hope this will help.

Best,

Sunny

mazacini
Contributor III

Re: Red for negative, Green for Positive on Bar Charts in Qlik Sense

Thanks sunny,

Worked perfectly.

Regards

Joe

Community Browser