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: 
Not applicable

question about round function

Hi ,

I am not able to understand the round function.

When I used round(78.32,1,1) it gave me 100

but when I used round(78.32,0.01) it gave me 78. Can anyone please explain this?

6 Replies
Not applicable
Author

Here is an explanation of the function

How round function work in qlikview

Not applicable
Author

Hi, I placed =round(78.32,1,1) into a text box and it displayed 78. I am unsure of what is wrong.

hic
Former Employee
Former Employee

You must be doing something else also, for example rounding in a second step on the Numbers tab. The Round() function does not work like you describe. See picture below

HIC

Round.png

Not applicable
Author

I am not sure but I guess since it's a percentage that's why I was getting the issue.

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

in the number tab use the option "Expression default" and then let the round function do the rest, so your number is expressed correctly,

regards

Not applicable
Author

Thank you everyone. It worked