topic How to handle 0 values in a % calculation in QlikView

How to handle 0 values in a % calculation

helen_pip — Fri, 13 Jan 2017 09:48:01 GMT

Dear Qlikview user

I have a dataset which is being loaded into Qlikview in the following format

Date Metric Numerator Denominator

01/01/2015 ABC 210 250

01/02/2015 DEF 107 195

01/03/2015 GHI 0 0

I load my data into Qlikview and then have a simple calculation to find out the %

I.e. Numerator/Denominator

However my Metric GHI which has 0 values in the column is displaying a null value. If I go the presentation tab and change the Null symbol from a '-' to a 0, it displays this value in my table as text

Can someone kindly help me write an expression which will return a 0% for the metric which is returning null values

Any help is greatly appreciated

Kind Regards

Helen

Re: How to handle 0 values in a % calculation

MindaugasBacius — Fri, 13 Jan 2017 09:57:30 GMT

Try in Presentation tab disable:

Re: How to handle 0 values in a % calculation

helen_pip — Fri, 13 Jan 2017 10:00:34 GMT

Thank you for your suggestion, but this still returns a Null value

Thanks

Helen

Re: How to handle 0 values in a % calculation

MK_QSL — Fri, 13 Jan 2017 10:01:57 GMT

Alt(Numerator/Denominator,0)

Go to presentation tab and untick Suppress Zero-Values

Re: How to handle 0 values in a % calculation

MindaugasBacius — Fri, 13 Jan 2017 10:03:46 GMT

Combine the previous suggestion with the Expression:

If(Numerator = 0, 0, Numerator/Denominator)