Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Meanwhile, you could try the following
If(Denominator<0, Fabs(Your Expression), YourExpression)
Hi, thanks Brett this is actually good news. i will forward to our admins.
Hi Vamsee, thanks for the response. we do have a work around as it is trivial once weve figured its a "bug".
@Brett_Bleess we finally upgraded and yes the problem was resolved. happy ending to that chapter