10 Replies Latest reply: Jul 15, 2016 5:16 AM by Joseph Landry

negative values in stacked line chart

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.

• Re: negative values in stacked line chart

Hi Joseph,

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

Regards

Miguel del Valle

• Re: negative values in stacked line chart

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

• Re: negative values in stacked line chart

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

• Re: negative values in stacked line chart

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.

• Re: negative values in stacked line chart

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

• Re: negative values in stacked line chart

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.

• Re: negative values in stacked line chart

Hi Joseph,

Regards

Miguel del Valle

• Re: negative values in stacked line chart

Hi Miguel,

thank You but it is not what I'd like to do.

The best solution seems to be using a non-stacked line graph with sum of previous expressions (A+B+C instead of C) it is less pretty than a stacked chart but it is accurate.

thank you for your answers, I will mark this issue as resolved.

• Re: negative values in stacked line chart

And can you please share me number tab screen shot

• Re: negative values in stacked line chart

Hi Anil,

You can try stacked.qvw which illustrate the problem.

Regards