topic Pie Chart? in QlikView

Pie Chart?

Nagaraju_KCS — Tue, 19 Feb 2013 18:10:09 GMT

Is it possible to show negative values on pie chart?

Gysbert_Wassenaar — Tue, 19 Feb 2013 18:17:44 GMT

Yes, but you can't show negative and positive values at the same time. That's meaningless anyway in a pie chart so that shouldn't be a problem.

Nagaraju_KCS — Tue, 19 Feb 2013 18:29:34 GMT

Thanks Gybsert,

Got a Problem I don't want to show negative values on pie chart, please help me. Below is the output of showing negative values.

got this problem (Positive and Negative values in chart)

erichshiino — Tue, 19 Feb 2013 18:36:44 GMT

HI,

How do you want to handle negatives?

If you just want to ignore them, you can set negatives to zero using rangemax()

if your expression is sum(value), you can use rangemax( sum( value), 0 )

It will compare sum(value) and 0 and get the max of them.. Thus, the minimum value is 0, replacing negative values.

Is it enought? If not, please, let us know

Regards,

Erich