Seprate positive and negative values in Bar chart

[sabahat_quazi]

Hello Everyone,

I want to show positive and negative values in bar chart.

I have attached sample qvw

here if I select N_Flag=0 it gives me positive values in chart

select N_Flag=1 it gives me negative values in chart

If I do not select N_Flag= it calculates net values(which I do not want)

My requirement is to display positive and negative values in single chart.

Please suggest if there is any solution.

Regards,

Sabahat

[sunny_talwar]

Not sure if this is the best way to do this, but what if you add N_Flag as your second dimension here

[sabahat_quazi]

Thanks Sunny for your quick reply.

But I need one bar for each 'To Product'.

Is there any other workaround?

[sunny_talwar]

Something like this?

[sabahat_quazi]

Like below

[vinieme12]

Yes you can, just add one expression for each segment

Check the attached

    

[vinieme12]

sample app

[sunny_talwar]

May be try this

Butterfly chart example

[sabahat_quazi]

Thanks Vineet.

Good Suggestion. But Number of products are not fixed ,they could increase in future. So in such case ,this approach wont work.

[sabahat_quazi]

Hi Sunny,

For butterfly chart ,need to bring the data in format as given in attached example.

Can consider this option if we can format the data .

Thanks for your Suggestion!!