Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Tags (2)
5 Replies
Chanty4u
Esteemed Contributor III

Re: Negative values in pie chart

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

Chanty4u
Esteemed Contributor III

Re: Negative values in pie chart

or u can use

FABS(expression) to use absolute value.


lik

FABS(Sum(Value))

undergrinder
Valued Contributor II

Re: Negative values in pie chart

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
Valued Contributor

Re: Negative values in pie chart

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

Re: Negative values in pie chart

Hi Betty,

Try changing your measure expression like

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

Regards,

Rohan

Community Browser