negative values in stacked line chart

[#1]

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.

[migueldelval]

Hi Joseph,

You can use a conditional expression that change the exp... if the value it´s less than zero.

Regards

Miguel del Valle

[#3]

I'd like to display the negative values, it should not break the display of other values.

[migueldelval]

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

[#5]

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.

[migueldelval]

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

[#7]

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

[migueldelval]

Hi Joseph,

Try this example, Please. Maybe it can help you in your visualitation.

Regards

Miguel del Valle

[Anil_Babu_Samineni]

How your expression looking.

And can you please share me number tab screen shot

[#10]

Hi Anil,

You can try stacked.qvw which illustrate the problem.

Regards