# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor III

## 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

9 Replies
Esteemed Contributor

## 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?

Esteemed Contributor

## 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

Contributor III

## 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

Valued Contributor

Like this?

Contributor III

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

yes exactly like this.

Esteemed Contributor

## 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:

Contributor III

## 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

Contributor III

## 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

Contributor III

Hi Mohan,