topic Re: Error in expression values(minus sign for 0 value) in QlikView

Error in expression values(minus sign for 0 value)

Thu, 13 Feb 2014 06:32:23 GMT

hello

I have derived one metrics in report.

Sales growth=(current sales-prev sales)/(prev sales)

In report current and prev values are same. So ideally it should display 0.0%

But it is displaying -0.0%.

There should not be any sign for 0 value.

Please find the attached image.

Thanks in Advance !!!

MK_QSL — Thu, 13 Feb 2014 06:33:48 GMT

if you make these numbers to two decimal, there could be difference.

please check and let us know

vikasmahajan — Thu, 13 Feb 2014 06:37:27 GMT

Go to Numbers -> Decimal -> 2 digit then it will show some fractional value it is not zero in your case.

Vikas

Thu, 13 Feb 2014 06:45:07 GMT

I have checked upto 5 decimals,but values are exact same.

MK_QSL — Thu, 13 Feb 2014 06:48:11 GMT

You can use below expression...

If(current sales = prev sales , 0, ((current sales-prev sales)/(prev sales)))

Thu, 13 Feb 2014 07:12:30 GMT

Instead of percentage in the Numbers tab, tey showing it decimals or number format.

or you can try below:

(num(current sales)-num(prev sales))/(num(prev sales))

Thu, 13 Feb 2014 07:21:35 GMT

I can't hardcode the values. Is there any other option for the same.

Or is anyone have idea that why the 0 is getting minus(-) sign.

Thu, 13 Feb 2014 07:23:59 GMT

I have tried by the same way.

I have changed the decimal format to number. But it is displaying -0.

MK_QSL — Thu, 13 Feb 2014 07:27:34 GMT

have you used...

If(current sales = prev sales , 0, ((current sales-prev sales)/(prev sales)))

jonathandienst — Thu, 13 Feb 2014 07:30:00 GMT

This is a rounding error from the floating point arithmetic. Use Round() to eliminate:

=Round((current sales-prev sales)/(prev sales), 0.1)

HTH

Jonathan