topic Re: BarChart separate negative and positive values in QlikView

BarChart separate negative and positive values

l_denivelle — Fri, 30 Dec 2016 15:18:51 GMT

I'm summing an amount of money which can be positive or negative and Qlikview naturally sum the positive and negative values together :

I would like to separate the negative values from the positive values and then present them in a BarChart like this :

Do you have any solution ?

Regards

Re: BarChart separate negative and positive values

sunny_talwar — Fri, 30 Dec 2016 15:31:37 GMT

May be using two expressions

1) Positive

2) Negative

Re: BarChart separate negative and positive values

Anil_Babu_Samineni — Fri, 30 Dec 2016 15:33:54 GMT

It will show default, What the issue you are facing. Can you send the expression or Application to work on same

OR Use background color like below

If(Sum(Sales) >= 0, Green(), Red())

Re: BarChart separate negative and positive values

Miguel_Angel_Baeyens — Fri, 30 Dec 2016 15:36:50 GMT

Sunny's suggestion will work. If you need those negative values for a different chart, you can always use the Fabs() function in the script and duplicate that field with absolute value for that chart and type of analysis, where you want to see the values separately, and the original, negative value where you can add or subtract in a different chart or expression.

Re: BarChart separate negative and positive values

MarcoWedel — Sat, 31 Dec 2016 00:12:02 GMT

Hi,

another solution might be a calculated dimension and a single expression:

hope this helps

regards

Marco

Re: BarChart separate negative and positive values

l_denivelle — Wed, 04 Jan 2017 08:17:30 GMT

Thank you I managed to do it with your solution !