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

[mazacini]

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

[sunny_talwar · Accepted solution]

Like this?

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()

I hope this will help.

Best,

Sunny

[mazacini]

Thanks sunny,

Worked perfectly.

Regards

Joe