BarChart separate negative and positive values

[l_denivelle]

Hi

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

[sunny_talwar]

May be using two expressions

1) Positive

2) Negative

[Anil_Babu_Samineni]

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())

[Miguel_Angel_Baeyens]

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.

[MarcoWedel · Accepted solution]

Hi,

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

hope this helps

regards

Marco

[l_denivelle]

Hi

Thank you I managed to do it with your solution !