Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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?

Tags (1)
6 Replies
Not applicable

Re: question about round function

Here is an explanation of the function

How round function work in qlikview

Not applicable

Re: question about round function

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

Re: question about round function

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

Re: question about round function

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

Partner
Partner

Re: question about round function

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

Re: question about round function

Thank you everyone. It worked