topic Re: How to use the Round () function? in QlikView

How to use the Round () function?

Anonymous — Wed, 11 Oct 2017 15:29:55 GMT

Hi,

I am trying to use the round function on the following expression:

Count(DISTINCT If([Escalated Case Count] = 1, CustomID, Null())) / SUM ({$}[Open Count])

What I did, was to add the Round at the beginning of the expression, but looks like it's not working at all. It's not calculating it. I also have tried to use it before the CustomID, but the expression show me an error.

Can you please provide me any guidance on where can I use the Round function for this specific expression.

Thanks,

Re: How to use the Round () function?

marcus_sommer — Wed, 11 Oct 2017 15:41:25 GMT

I think I would use:

round(Count({< [Escalated Case Count] = {1}>} DISTINCT CustomID) / SUM ([Open Count]))

- Marcus

Re: How to use the Round () function?

Anonymous — Wed, 11 Oct 2017 15:51:27 GMT

I did that, but all the numbers became 0

Re: How to use the Round () function?

sunny_talwar — Wed, 11 Oct 2017 16:42:53 GMT

Round to how many decimals? It seems you have a division, is numerator smaller or bigger then the denominator?

Re: How to use the Round () function?

Anonymous — Wed, 11 Oct 2017 16:49:11 GMT

you're right. I have small numbers as 0.24, 0.02 and so. This won't work

Re: How to use the Round () function?

sunny_talwar — Wed, 11 Oct 2017 16:54:09 GMT

May be Round to a decimal number

Round(Expression, 0.001)

Re: How to use the Round () function?

Anonymous — Wed, 11 Oct 2017 16:58:50 GMT

Thank you, that worked!!!

Re: How to use the Round () function?

christian77 — Fri, 24 Nov 2017 13:56:12 GMT

I don't think it Works.

tABLA:
LOAD
trim(round(A,0.01))
FROM

(ooxml, embedded labels, table is Hoja1);

And the view is

1,2600000000000

3,6500000000000

7,3300000000000

800,0000000000000

1.533,1500000000001

when the original numbers are. One of these days will be fixed

1,264560000000000000000

3,654654654654650000000

7,330000000000000000000

800,000000000000000000000

1533,153300000000000000000

Re: How to use the Round () function?

marcus_sommer — Fri, 24 Nov 2017 14:16:30 GMT

What is the problem?

Re: How to use the Round () function?

Anonymous — Fri, 24 Nov 2017 14:43:15 GMT

There is not any problem, this was resolved a few months ago.

Re: How to use the Round () function?

marcus_sommer — Fri, 24 Nov 2017 14:51:28 GMT

My answer was directed to the current question from christian77.

Re: How to use the Round () function?

christian77 — Mon, 27 Nov 2017 08:21:35 GMT

Hi Marcus.

1.533,1500000000001

Do you see the last decimal? ...001. That is the problema. It does NOT round.

I'm using version 12.10.20000.0 SR2

The first versión I used was 8.5

Thanks.

Re: How to use the Round () function?

marcus_sommer — Mon, 27 Nov 2017 08:28:43 GMT

This behaviour is related to the used binary number-system which is very well explained here: Rounding Errors.

- Marcus

Re: How to use the Round () function?

christian77 — Tue, 28 Nov 2017 12:17:19 GMT

Hi Marcus.

Thanks, now I understand everything. That was it! Floating binary decimal numbers written in hexadecimal. Perfect! Awesome!

Now, do we have something for this world, here on earth?

We have thousands of those numbers.

Differences are wrong, because numbers are binary.

How I’m going to explain that to my client?

Re: How to use the Round () function?

marcus_sommer — Tue, 28 Nov 2017 14:03:58 GMT

Explaining ... it's just a design-decision from the past because of performance reasons (for example quite similar to Excel). Handling ... will be difficult and depends on the specific use-case maybe with round off/up to fewer digits, maybe a hard-cutting and probably some more measures ... but if the application needs to handle quite large/small number with many digits and a high degree on accuracy you might need a different tool.

- Marcus