topic Re: num function shows -0% when divisor is negative in QlikView

num function shows -0% when divisor is negative

edwin — Sat, 16 Nov 2024 18:09:55 GMT

Hi,

we are currently encountering this issue and cant find any reference to it anywhere:
when using num(formula,'#.##%;(#.##%)'). when we have normal values like 1/12, or 1/-12 we get the expected values and formats (negatives in brackets). however, when we have calculations like 0/-12, the formatting is overridden and we get -0.00%

these are the sample scenarios:

=num(0/-12, '#.##%;(#.##%)') =num(0/12, '#.##%;(#.##%)') =num(1/-12, '#.##%;(#.##%)')

-0.00%

0.00%

(8.33%)

our expectation was for the first one to show 0.00% not -0.00%

we are using Qlikview Nov 2017 SR5 Version 12.20.20600.0

i noted that when i use the desktop edition, the first scenario is represented correctly as 0.00%

thanks,

edwin.

Re: num function shows -0% when divisor is negative

Brett_Bleess — Tue, 15 Sep 2020 18:16:29 GMT

This appears to be a known issue with reference QV-14869 and is fixed in 12.30 and later tracks. You should be updating anyway, as support for 12.20 track will be ending in a couple of months, so I would suggest working on the update to 12.30 or later track to avoid being out of support come November and if you still see the issue post upgrade, open a support case with us. I do not believe R&D will entertain address anything like this in the 12.20 track given the closeness to the support expiration of the release. Sorry I do not have better news for you.

Regards,
Brett

Re: num function shows -0% when divisor is negative

vamsee — Tue, 15 Sep 2020 19:15:14 GMT

Meanwhile, you could try the following

If(Denominator<0, Fabs(Your Expression), YourExpression)

Re: num function shows -0% when divisor is negative

edwin — Tue, 15 Sep 2020 19:16:46 GMT

Hi, thanks Brett this is actually good news. i will forward to our admins.

Re: num function shows -0% when divisor is negative

edwin — Tue, 15 Sep 2020 19:18:08 GMT

Hi Vamsee, thanks for the response. we do have a work around as it is trivial once weve figured its a "bug".

Re: num function shows -0% when divisor is negative

edwin — Tue, 15 Dec 2020 21:23:05 GMT

@Brett_Bleess we finally upgraded and yes the problem was resolved. happy ending to that chapter