Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Negative values in pie chart

Hello everyone,

Does anyone know what "Data set contains negative values that can't be shown in the chart"? I've tried to supress the zeros, but it doesn't work. So I'm wondering how to Skip that line under the pie chart. A little help please? 😃

SkärmklippPieChart.PNG

Sincerely,

Betty Habtemariam

5 Replies
Chanty4u
MVP
MVP

pi chart is not the right object when you have negative values...! You need to use bar chart or line chart.

Chanty4u
MVP
MVP

or u can use

FABS(expression) to use absolute value.


lik

FABS(Sum(Value))

undergrinder
Specialist II
Specialist II

Hi Betty,

If you want to just exclude zeros you should make off the show zeros functions at the properties panel, and change your formula like this:

if(myformula<=0,'',myformula)

G.

puttemans
Specialist
Specialist

Hello Betty,

First question I have when I get such a message is whether there should be negative values... Most of the times, the negative values I got were wrong calculations that distorted the results. So my first solution would be to look critically at the data. Do they make sense if they are negative?

If they do make sense, then as already mentioned, a pie chart may not be the right way to show them (as a pie chart works in a cumulative way, you cannot create 'extra' pie with negative values).

Kind regards,

Johan

Not applicable
Author

Hi Betty,

Try changing your measure expression like

sum({$<YourMeasure={">0"}>}YourMeasure)

Regards,

Rohan