Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
xarapre7
Creator II
Creator II

QV is getting the 0% as a null when it supposed to include it as 0% in the expression

Hi!

In my expression for a straight table, QV is getting the 0% as a 'null' when it supposed to include it as the actual 0% in the expression.  Because of this, I'm getting 86% instead of 83%.  What is the correct expression to have it as the actual 0%?  My expression is:

IF(NOT ISNULL(SUM(Calls)/SUM(CallsOffered)),SUM(Calls)/SUM(CallsOffered), 0).  Please see attached for the sample. 

Thank you for your help in advance!

4 Replies
oscar_ortiz
Partner
Partner

Preciosa,

This looks to be a Divide by Zero issue.  Have you tried modifying your expression to something like this?

If ( SUM(CallsOffered) =0, 0, SUM(Calls)/SUM(CallsOffered) )


Good luck

Oscar

oscar_ortiz
Partner
Partner

Having a second look, maybe you can use Count() instead of Sum().

268097.PNG

xarapre7
Creator II
Creator II
Author

It worked!  Thank you for your help Oscar!!!

oscar_ortiz
Partner
Partner

Preciosa,

If you have found the advice helpful or correct, please close the post.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks

Oscar