Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to use the Round () function?

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,

1 Solution

Accepted Solutions
sunny_talwar

May be Round to a decimal number

Round(Expression, 0.001)

View solution in original post

14 Replies
marcus_sommer

I think I would use:

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

- Marcus

Anonymous
Not applicable
Author

I did that, but all the numbers became 0

sunny_talwar

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

Anonymous
Not applicable
Author

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

sunny_talwar

May be Round to a decimal number

Round(Expression, 0.001)

Anonymous
Not applicable
Author

Thank you, that worked!!!

christian77
Partner - Specialist
Partner - Specialist

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

marcus_sommer

What is the problem?

Anonymous
Not applicable
Author

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