Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

Seprate positive and negative values in Bar chart

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


Tags (1)
11 Replies

Re: Seprate positive and negative values in Bar chart

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

Capture.PNG

Partner
Partner

Re: Seprate positive and negative values in Bar chart

Thanks Sunny for your quick reply.

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

Is there any other workaround?

Re: Seprate positive and negative values in Bar chart

Something like this?

Capture.PNG

Partner
Partner

Re: Seprate positive and negative values in Bar chart

Like below

vinieme12
Esteemed Contributor II

Re: Seprate positive and negative values in Bar chart

Yes you can, just add one expression for each segment

Check the attached

     multisegment.PNG

vinieme12
Esteemed Contributor II

Re: Seprate positive and negative values in Bar chart

sample app

Re: Seprate positive and negative values in Bar chart

May be try this

Butterfly chart example

Partner
Partner

Re: Seprate positive and negative values in Bar chart

Thanks Vineet.

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

Partner
Partner

Re: Seprate positive and negative values in Bar chart

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