Discussion Board for collaboration on QlikView Layout & Visualizations.
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 ?
You can use a conditional expression that change the exp... if the value it´s less than zero.
Miguel del Valle
I'd like to display the negative values, it should not break the display of other values.
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.
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.
The problem is that this type of graph it´s based in areas, and always sum the values to show the equivalent area.
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
Try this example, Please. Maybe it can help you in your visualitation.
How your expression looking.
And can you please share me number tab screen shot
You can try stacked.qvw which illustrate the problem.