Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Pie chart Issue

Hi All,

      When I try to show the negative values in Pie chart it shows me an error

"Positive and Negative values in chart".. Is there any way of shwing the negative values in the pie chart...

Plz let me know if you have any answer for this...

Thanks,

Lavanya

2 Replies
MVP
MVP

Pie chart Issue

Lavanya

A pie chart can show all negative values, but only if all the values are negative. It cannot display a mix of positive and negative. A pie chart pretty meaningless when you have a mix of positive and negative values.

If you must use a pie chart, you can modify your expressions like this:

=RangeMax(your_expression, 0) to clip out negatives and display only positives

=RangeMin(your_expression, 0) to clip out positives and display only negatives

Hope that helps

Jonathan

Not applicable

Re: Pie chart Issue

I Have suggested them for a table chart where they can see the mixture of positive and negative values. Thanks for your reply….