Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

singhpooja
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
omarbensalem
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?

omarbensalem
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

singhpooja
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

michielvandegoo
Valued Contributor

Re: Showing positive and negative values in bar chart

Like this?

comm289580.jpg

singhpooja
Contributor III

Re: Showing positive and negative values in bar chart

yes exactly like this.

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

dim : LeadTime

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

reuslt:

Capture.PNG

mohan_1105
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

After loading, create the bar chart having two dimension(Your Dimension, Num_flag) and the measure(Your_measure).

singhpooja
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

singhpooja
Contributor III

Re: Showing positive and negative values in bar chart

Hi Mohan,

I got my answer and actually I don't require flag things. Thanks for your reply.

Regards,

Pooja