topic Re: Pie chart Issue in QlikView

Pie chart Issue

Fri, 17 Jun 2011 08:04:39 GMT

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

Pie chart Issue

jonathandienst — Fri, 17 Jun 2011 10:12:09 GMT

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

Re: Pie chart Issue

Fri, 17 Jun 2011 10:16:40 GMT

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