Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
An expression in my chart can be negative, and it breaks the stacked area.
the 'non Estimé' expression is always 0 but it appears to be negative on the whole period of time.
this is due to the 'non réglé' expression being negative.
when no expression is negative the chart is correct.
any hint on how to fix this ?
Thanks.
Hi Joseph,
You can use a conditional expression that change the exp... if the value it´s less than zero.
Regards
Miguel del Valle
I'd like to display the negative values, it should not break the display of other values.
Hi Joseph,
YOu are using a combo visualitation, And it´s dificult to solve it.
Try to use =IF([non réglé]>'0', sum([non facturé], ((sum([non reglé])*0)+(sum([non facturé]))).
Please, let me Know if it´s correct.
Regards
Miguel del Valle
Hi Miguel,
This is not a combo graph, it is a line one.
idealy, on this set of data, the 'non estimé' area would not be visible.
here is a small file to illustrate the problem. the A value is always 0 and I would like it not to be visible.
moreover, at the key=3 the C value appear to be 20 where it is in fact 10.
Hi Joseph,
The problem is that this type of graph it´s based in areas, and always sum the values to show the equivalent area.
Regards
Miguel del Valle
well, I have to admit it would be hard to visualize negative values stacked on positive values, I'll have to think of a better way to display this.
thank you for your help
Hi Joseph,
Try this example, Please. Maybe it can help you in your visualitation.
Regards
Miguel del Valle
How your expression looking.
And can you please share me number tab screen shot
Hi Anil,
You can try stacked.qvw which illustrate the problem.
Regards