topic Re: Bar Chart - Get the chart empty instead a error message in QlikView

Bar Chart - Get the chart empty instead a error message

Wed, 13 Jan 2016 14:20:47 GMT

I have the following message because the value of my expression is 0. But how do I put the chart back to 0 values instead of an error message?

Thanks!

Re: Bar Chart - Get the chart empty instead a error message

sunny_talwar — Wed, 13 Jan 2016 16:55:48 GMT

Remove the calculation condition on General tab:

Re: Bar Chart - Get the chart empty instead a error message

Wed, 13 Jan 2016 16:58:10 GMT

You need to uncheck the Suppress Zero Values option on the Properties.

Chart Properties --> Presentation --> Un check "Supress Zero Values" (find on the bottom left hand side)

Note: Please make sure that your expression return 0 value. If expression returns Null value you need uncheck Supress Missing option.

Re: Bar Chart - Get the chart empty instead a error message

Wed, 13 Jan 2016 17:01:56 GMT

you will need to unchec the supress values if zero options (this is available for dimensions and expressions. You can slo customize the message that displays if you would like as well - on the General tab, Error Message buttonn at bottom