Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you want to show ur bar chart in 2 directions, but keep the valuepositive for both measures?
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
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
Like this?
yes exactly like this.
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:
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).
Hi Omar .. some how its not working for me . Anyway got some idea from your butterfly chart thins.
Thanks
Pooja
Hi Mohan,
I got my answer and actually I don't require flag things. Thanks for your reply.
Regards,
Pooja