topic Re: Help with round function in QlikView

Help with round function

qlikuser222 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I need help with round function.

round(0.2461412134614245,.0001) and round(0.2753054367009194,.0001)

How can i get the output for the above number as follows - 24.6% and 27.6% ?

Thanks

Re: Help with round function

pradosh_thakur — Mon, 01 Apr 2019 18:39:16 GMT

text box

=round(0.2461412134614245,.001) * 100 & '%'

Re: Help with round function

qlikuser222 — Mon, 01 Apr 2019 18:45:20 GMT

Thnaks,

=round(0.2753054367009194,.001) * 100 & '%' = 27.5%

but i need 27.6%

Thanks

Re: Help with round function

dplr-rn — Mon, 01 Apr 2019 19:30:15 GMT

What is your threshold/logic for the rounding up?
27.53 you want as 27.6 and 24.61 you want as 24.6.
You can use ceil function to force rounding up but it will be becore 27.6 and 24.7 respectively.

Re: Help with round function

danilostochi — Tue, 02 Apr 2019 03:25:23 GMT

=num(ceil(num(num(.2461412134614245)*100),0.01),'#.##0,0')

=ceil(num(num(0.2753054367009194)*100),0000.1)

Re: Help with round function

jonathandienst — Tue, 02 Apr 2019 06:34:31 GMT

If its just for display purposes, then keep it simple and use Num():

Num(0.2461412134614245, '%0.0')

If its for other (non-display) purposes where need the rounded values (eg a dimension), then the % sign may be unnecessary and use:

Round(0.2461412134614245, 1/1000)   // if its used internally or in script
or 
Num(Round(0.2461412134614245, 1/1000), '%0.0')   // for a dimension

Re: Help with round function

Brett_Bleess — Wed, 15 May 2019 17:50:54 GMT

Some of the guys above have already hit on things, but I am going to through out a Design Blog post for you as well, that might help things make a bit more sense. The only way I see to get what you want is to change your offset value from .0001 to .001, that should do the trick as well, but as things are, they are working as expected from what I can see. Using the step option could work, but I am betting you do not want to go up or down a whole integer either. Thanks to the other guys above comments as well, they are all good, just hoping this one may fill in the gaps a bit for you.

https://community.qlik.com/t5/Qlik-Design-Blog/Rounding-Errors/ba-p/1468808

Regards,
Brett