"There is not data to show"

[pgalvezt]

Hi all, I comment you that I have a Dashboard that shows different values of production. In some cases this value gives Zero. So, How you know any values divide by 0 is Error. My formula is Charge divide by Production. For visual efects, this massage "There is no data to show" is not very nice for the customer. Is there another way to change that in QlikView. Simply a 0 for example.

Thanks!

[jagannalla]

Your expression is now like this ... =5/0

- 5 is coming from one field and 0 is coming from another field. Then write your expression as below

Write now i have taken example with straight table object..

=if(F3=0,'Error',F2/F3)

Result will be ...

- May be it helps you.

[#3]

Try using Chart Properties ->General -> Error messages.

Kiran.

[#4]

Hi there,

have a look at this thread

http://community.qlik.com/message/145485#145485

you can use a dummy expression and calculated condition to change the error message you see within the chart, to one that is editable as you see fit

hope that helps

thanks

Joe

[rrsrini2907]

I think you cannot override error message for divide by zero.

Regards,

Srini.

[pgalvezt]

Thank you all for your replies!

J Simmons The solution that you gave me worked perfectly, but when the result is valid for example 3/3 = 100%. That condition change the result to 0%.

Any suggestion?

Thanks again.

[#7]

hmm post your updated qvw and I'll take a look no worries

thanks

Joe

[#8 · Accepted solution]

realised you can do this without the need for the dummy expression and just use the conditional calculation instead, please see attached example should work fine for you now

thanks

Joe

[pgalvezt]

Thanks!!