Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
if(yourcalc > 0, round(yourcalc), '')
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
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