How do I show a blank when there is negative or zero value?

[Anonymous]

Hi All,

I wish to display a pie chart.

However, there are some negative values and the app will show the error "The chart is not displayed because it contains negative or zero values".

I understand that a pie chart is never good to display a negative value. But is it possible for the app to show a blank space instead of displaying the error?

thanks in advance!

[rubenmarin]

Hi guohao, this question is for QlikView or QlikSense?

If QlikView, in design tab you can set the 'Show' condition to an expression that checks if there will be negative values as said in my previous post, have you tried that?

If you want to show a customized message you can try with the 'calculation condition' on the General tab

If QlikSense you can do the same in 'Aditional modules' --> 'Calculation condition'

[ronman10]

Hi Guohao,

Any idea as to how this expression would work in case of percentages.

Regards,

Rony