topic Re: Rounding up in QlikView

Rounding up

jlampard40 — Sat, 16 Nov 2024 02:13:24 GMT

Hi - I have a straight table and calculating % compliance. I also want to calculate the amount of reviews needed to achieve compliance at 92%. So, I've started calculating this in columns within the tables. All working OK, until I need to add the final column which basically rounds UP column 6 to nearest whole integer but ONLY if the number if greater than zero. If less than zero, I'd like it to not be displayed to be honest, so only showing those integers above zero and as a rounded up number. Many thanks.

Re: Rounding up

rwunderlich — Tue, 15 Oct 2019 15:00:15 GMT

if(yourcalc > 0, round(yourcalc), '')

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Rounding up

Brett_Bleess — Tue, 22 Oct 2019 13:50:23 GMT

James, did Rob's post help you get what you needed? If so, be sure to use the Accept as Solution button on his post to give him credit and let others know it worked. If you are still working on things, leave us an update, so we can try to see if anyone can come up with something else that may work.

Regards,
Brett