Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
another solution might be a calculated dimension and a single expression:
hope this helps
regards
Marco
May be using two expressions
1) Positive
2) Negative
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())
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.
Hi,
another solution might be a calculated dimension and a single expression:
hope this helps
regards
Marco
Hi
Thank you I managed to do it with your solution !