9 Replies Latest reply: Jan 31, 2018 12:16 AM by Pooja Singh

# Showing positive and negative values in bar chart

Hi Experts,

My requirement is adding positive and negative values in bar chart. is there any way to show bar chart in both direction (postive and negative)?

Thanks & Regards,

Pooja Singh

• ###### Re: Showing positive and negative values in bar chart

you want to show ur bar chart in 2 directions, but keep the valuepositive for both measures?

• ###### Re: Showing positive and negative values in bar chart

if it's so; please refer to this:

How to create a Butterfly (Tornado) Chart in Qlik Sense

if u have one positive measure and one negative measure, you just add them as 2 measures in ur bar chart without changing a thing and u'll have ur bar automatically in both directions

• ###### Re: Showing positive and negative values in bar chart

Hi Omar,

Thanks for your reply . I gone through your following article but that is not my requirement. For me  I need one dimension with single expression and that expression has both positive and negative no. In my bar chart I want to show both positive and negative bars.

Thanks,

Pooja

• ###### Re: Showing positive and negative values in bar chart

Like this?

• ###### Re: Showing positive and negative values in bar chart

yes exactly like this.

• ###### Re: Showing positive and negative values in bar chart

then just create a bar chart, put ur dimension and ur measure and it will automatically happens:

example:

measure: sum(Sales) : it contians both negative and postive values

reuslt:

• ###### Re: Showing positive and negative values in bar chart

Hi Omar .. some how its not working for me . Anyway got some idea from your butterfly chart thins.

Thanks

Pooja

• ###### Re: Showing positive and negative values in bar chart

Pooja,

Create the flag in back-end by,

If(your_measure>0,1,0) as Num_flag

• ###### Re: Showing positive and negative values in bar chart

Hi Mohan,