Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
robertocesp
Creator II
Creator II

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
MVP & Luminary
MVP & Luminary

I think I would use:

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

- Marcus

robertocesp
Creator II
Creator II
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?

robertocesp
Creator II
Creator II
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)

View solution in original post

robertocesp
Creator II
Creator II
Author

Thank you, that worked!!!

christian77
Partner
Partner

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
MVP & Luminary
MVP & Luminary

What is the problem?

robertocesp
Creator II
Creator II
Author

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