Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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.

Capture d’écran 2016-07-12 à 11.33.22.png

10 Replies
migueldelval
Valued Contributor

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

Not applicable

Re: negative values in stacked line chart

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

migueldelval
Valued Contributor

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

Not applicable

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.

Capture d’écran 2016-07-13 à 10.55.47.png

moreover, at the key=3 the C value appear to be 20 where it is in fact 10.

migueldelval
Valued Contributor

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

Not applicable

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.

thank you for your help

migueldelval
Valued Contributor

Re: negative values in stacked line chart

Hi Joseph,

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

Regards

Miguel del Valle

Re: negative values in stacked line chart

How your expression looking.

And can you please share me number tab screen shot

Life is so rich, and we need to respect to the life !!!
Not applicable

Re: negative values in stacked line chart

Hi Anil,

You can try stacked.qvw which illustrate the problem.

Regards

Community Browser