topic Re: Round with a fixed digit in QlikView

Round with a fixed digit

Black_Hole — Sat, 16 Nov 2024 02:35:50 GMT

Hello all,

I would like to round to the eleventh digit.

I tried the function: Round(Sales,11,0.01). But this is not the expected result.

Please could tell how can I do that.

Many thanks in advance for your help.

Re: Round with a fixed digit

marcus_sommer — Fri, 30 Aug 2019 11:30:05 GMT

Try: Round(Sales, 0.00000000001)

- Marcus

Re: Round with a fixed digit

Brett_Bleess — Mon, 09 Sep 2019 21:37:23 GMT

Sou, just providing the Help link for the Round function as well in addition to what Marcus posted.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/GeneralNumericFunctions/round.htm

If you find things are not working per what is documented in the Help, there are only two things I could suggest, check that you are running the latest service release (SR) for the major version you are running, these are:

11.20 SR19

12.10 SR11

12.20 SR9

12.30 SR3

12.40 SR1

If you are on one of those, then this may be something defect related, and will likely be best to open a support case with us at that point, if you can provide an example app if you do that, that should help us check things pretty quickly.

Regards,
Brett

Re: Round with a fixed digit

Black_Hole — Wed, 11 Sep 2019 07:17:19 GMT

Hello @marcus_sommer , @Brett_Bleess ,

Thank you both for your help.

@marcus_sommer : Your solution give me the result expected. I wonder if there is a way to optimize the second parameter of the function round(), for example to precise directly the number of decimals. Maybe not with the function round(), but if there is another function in QVW I will be really interesting to know it ?!

@Brett_Bleess : Thank you for sharing the link.

Re: Round with a fixed digit

marcus_sommer — Wed, 11 Sep 2019 07:53:25 GMT

You could also use an expression to define the digits of the rounding, maybe with:

= round(14.5489627892171, 1 / pow(10, 😎)

and you could also create a customized function with the help of a variable for it, for example:

eRound:
round($1, 1 / pow(10, $2))

and then calling it with:

$(eRound(14.5489627892171, 8))

- Marcus

Re: Round with a fixed digit

Black_Hole — Thu, 12 Sep 2019 09:57:28 GMT

Hi @marcus_sommer,

Your solution is great.

Many thanks for your help.